Number Formatting

[Angel1015]

Have created an speadsheet with a column for dollar amounts. Have formatted
cells in that column for Currency with 2 decimils. Using this spreadsheet
for Mail Merge in Word but each time I pull information from the cells in the
column formatted for currency, the dollar amounts that end in .00 don't show
the .00. For instance $14.00 shows as $14 and $.50 shows as $.5 Anyone know
a way to fix this??? It is driving me insane. Thanks in advance for any and
all suggestions.

 

[Dave Peterson]

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/assistance/HA011164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/CustomizingWord2002.htm