Format merged number field as currency

[rjr1040]

Hello,
Word XP, operating on Windows XP. I have a WORD merge file using excel as
it's database. I researched and discovered the field code alteration to make
it display two decimal places "{mergefield cost \# "0.00" } BUT when it is
in the thousands of dollars 1,256.83 I can't get the comma to display. It
displays as 1256.83.

I've searched and can't find the answer, I would appreciate suggestions.
Thanks
Bob Reynolds

 

[Greg]

Bob,

Try
\# ",$#.00;(,$#.00)"

This will include the comma and parens around negative
numbers. Delete the $ if you don't want to display it.

 

[rjr1040]

Thanks Greg, That did it.
Appreciate your help
Bob

 

[rjr1040]

OOPS, Greg that gives me the comma before the numbers. I thought to change
it to $ #,###.00 and it works great with a number over 1,000 but the comma
is still inplace for numbers less than 1,000 like 985.02....
Any ideas cause I have different amounts below and above 1,000

Thanks
Bob

 

[rjr1040]

OOps That didn't do it.
That puts the comma in front of the numbers and I altered it to be $
#,###.00 and it works for the 1,000 plus but not for the less than 1,000.
ANy ideas???

 

[Greg Maxey]

Bob,

I did goof and get the comma in front of the $, but \# "$,#.00;($,#.00)" is
working for for numbers less than a thousand here. Field codes can be
tricky. Try starting from scratch using the numerical switch above.