Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
0 missing from currency when merging documents
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
0 missing from currency when merging documents
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/as...164951033.aspx And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill has instructions he http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm about half way down the page. lyndamac wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Indicate missing number in a sequence (Part II) | Excel Discussion (Misc queries) | |||
excel documents won't open from my documents folder | Excel Discussion (Misc queries) | |||
Excel Documents Don't Appear in My Recent Documents | Excel Discussion (Misc queries) | |||
Currency Style button | Excel Discussion (Misc queries) | |||
Recent Documents Disappear (Excel / Office 2000) | Excel Discussion (Misc queries) |