| 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). |
| 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 | |||
Threaded Mode
