[Paulo]

i have a money value that is being merged from excel sheet.

when i hit ACB it shows "De R$7235,9200000000001" it how do I edit
that to show "De R$7235,92"

i have the same problem on the date i am getting this "2008-02-28 00:00:00"
i dont what the time on the format at all.

[Paulo]

reading alot of old topics I got the answer.

thanks any way.
ALSO thankS for Mr.GMAYOR FOR TUTORING THIS...

http://www.gmayor.com/mail_merge_lab...htm#Excel_data


"Paulo" wrote:

i have a money value that is being merged from excel sheet.

when i hit ACB it shows "De R$7235,9200000000001" it how do I edit
that to show "De R$7235,92"

i have the same problem on the date i am getting this "2008-02-28 00:00:00"
i dont what the time on the format at all.

[Peter Jamieson]

Try this...

Press Alt-F9

You should see either

{ MERGEFIELD ACB }
or
{ MERGEFIELD "ACB" }

Change that to
{ MERGEFIELD ACB \#"'De R$'0,00"}
or
{ MERGEFIELD "ACB" \#"'De R$'0,00"}

(I am sorry - I tried to work out whether your currency should show as "De
R$", but I am not sure)

If you have a date field such as

{ MERGEFIELD mydate }

then try for example

{ MERGEFIELD mydate \@"DD MMM YYYY" }

to get

03 Jul 2008
(or the equivalent 3-character monthname in the language set up on your
system)

You can use Alt-F9 again to show the "results" instead of the field codes.

You can find out more in Word Help.
--
Peter Jamieson
http://tips.pjmsn.me.uk

"Paulo" wrote in message
...
i have a money value that is being merged from excel sheet.

when i hit ACB it shows "De R$7235,9200000000001" it how do I edit
that to show "De R$7235,92"

i have the same problem on the date i am getting this "2008-02-28
00:00:00"
i dont what the time on the format at all.