[Graham Mayor]

I think there may be an issue relating to regional settings. Is '.' a
thousands separator in your Word version?
As fore the first item,
{ =ROUND({MERGEFIELD Total_Fijo_Mensual},0) }
should give you the nearest whole number.
The second field does not contain a date. You cannot derive a Word date from
it.
From the Tools menu in Word, select Options and then go to the General tab
and check the box against the "Confirm conversions at open" item. Then when
you attach the data source to the mail merge main document, you will be
given the option of using the DDE method of connection which should read the
data as you have it formatted in the table.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



wrote:
Without the switches I get,

{MERGEFIELD Total_Fijo_Mensual} 4389.44 ( I want no decimal places)

{MERGEFIELD Fecha_Ult_Increm} 38078

Thanks


What do
{MERGEFIELD Total_Fijo_Mensual}
and.....
{MERGEFIELD Fecha_Ult_Increm}
produce without the switches?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



wrote:
It's still not working. I've read your page, very good source.
neither of them are working Don't know what to do, I've updated the
values with F9 save it and opened it again.
I've tried this... ({MERGEFIELD "Total_Fijo_Mensual"\# "##.000}
and..... {MERGEFIELD Fecha_Ult_Increm \@ "dd/MM/yy"}
Don`t know what to do..
Thanks fotr your help




Graham Mayor ha escrito:

Try {MERGEFIELD Total_Fijo_Mensual \# "##.000"} (was that supposed
to be three decimal places?)
and {MERGEFIELD Fecha_Ult_Increm \@ "dd/MM/yy"}
and make sure the quotes are plain quotes and not smart quotes.
Having made the changes, update the fields
See also http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



wrote:
Sorry Macropod...

{MERGEFIELD "Total_Fijo_Mensual"\###.###}
{MERGEFIELD "Fecha_Ult_Increm"\@dd/mm/yy}

None is working.
Thanks for your help.
Gastsn




macropod ha escrito:

Hello Gaston,

Insufficient information! Please post samples of the mergefields
using these switches.

Cheers

--
macropod
[MVP - Microsoft Word]


wrote in message
ups.com...
Dear all,
I have a problem, a big one.
I`m trying to format mergefields and \# is not working, I`ve
tried everything... also \@ is not working.
I have Office 2003 SP1 in Spanish.
Thanks in advance