Home |
Search |
Today's Posts |
#1
|
|||
|
|||
in mail merge how do i convert currency from excel to word
I have a spreadsheet that uses currency. When I mail-merge into Word
document, the currency doesn't convert correctly. For example the $ sign does not come across, the diget 0 does not convert if its the last digit (i.e. in excel $20.50 - converts to Word in mail merge as 20.5) and if the currency does not end in 0, it converts with 4 digits after decimal point (i.e. $20.51 converts to 20.5142). |
#2
|
|||
|
|||
Use a numeric switch in your merge fields within Word. See "Numeric
Picture (\#) field switch" in Word Help. In article , amedeo wrote: I have a spreadsheet that uses currency. When I mail-merge into Word document, the currency doesn't convert correctly. For example the $ sign does not come across, the diget 0 does not convert if its the last digit (i.e. in excel $20.50 - converts to Word in mail merge as 20.5) and if the currency does not end in 0, it converts with 4 digits after decimal point (i.e. $20.51 converts to 20.5142). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
Serious Mail Merge Problem | Excel Discussion (Misc queries) | |||
How do I format an excel document to transfer to mail merge? | Excel Discussion (Misc queries) | |||
Extract Data for Mail Merge | Excel Discussion (Misc queries) | |||
Mail merge to a chart | Charts and Charting in Excel |