0 missing from currency when merging documents

[lyndamac]

Hi there,

I am merging a document from excel to word. When I merge them my
currency loses a 0 at the end.

i.e £7.50 ends up as £7.5 and I am manually adding in a 0 at the end
of each one. This is rather tedious as you can imagine, as there are
over 200 entries.

Is there anyway I can do this quickly, maybe my settings are wrong. I
have currency setup in excel - currency 2 decimal places.


Please help


Thanks

Lynda

 

[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

about half way down the page.