Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you keep Excel currency formatting during a mail merge?
I would like to be able to enter currency in Excel as a simple number (ex:
2000) and, when I merge the database to my MSWord Document using Mail Merge, I would like the number to show up formatted as currency (ex: $2,000.00). How do I do that? |
#2
|
|||
|
|||
Debra Dalgleish posted this to a similar question:
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://home.earthlink.net/~wordfaqs/...ngWord2002.htm about half way down the page. pejackso wrote: I would like to be able to enter currency in Excel as a simple number (ex: 2000) and, when I merge the database to my MSWord Document using Mail Merge, I would like the number to show up formatted as currency (ex: $2,000.00). How do I do that? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel conditional formatting error | Excel Discussion (Misc queries) | |||
in mail merge how do i convert currency from excel to word | Excel Discussion (Misc queries) | |||
Wrap text limits in Excel 2003 cell formatting | Excel Discussion (Misc queries) | |||
excel formatting | Excel Discussion (Misc queries) | |||
Changing Dollar sign to another currency not listed in Excel | Excel Discussion (Misc queries) |