Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
formatting numbers imported from excel in mailmerge
I am doing a mailmerge in Office 2007 with data imported from an excel
spreadsheet where one of the spreadsheet fields is calculated (to give a rate of exchange). The problem is that the word documents returns a figure to 10 decimal places. I have tried: a) putting the calculation in one column and then used ROUNDUP to convert the number to 2 decimal places and using that column for the field. (Word just returns 10 decimals) b) Changing the document parameters in Word Options _Advanced - General - confirm file format conversion on open. Same thing c) Saving the spreadsheet and closing it. Saving the Word Doc and closing it. Re-opening the word file and re-confirming the spreadsheet. Same thing. d) Rebooting my laptop and re-opening the files. Same thing. I am getting v frustrated - going through 300 merged letters and deleting 8 digits (and search and replace is not an option, there are too many variables) is too horrible to contemplate. This must have happened to other people and I'm sure there's a solution.... but, boy, would I be incredibly grateful to know what it is. thank you. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mailmerge numbers from Excel | Mailmerge | |||
search-replace: Formatting phone numbers imported from outlook | Microsoft Word Help | |||
Mailmerge keep formatting from Excel database or... | Mailmerge | |||
Formatting Graphs imported from Excel | Microsoft Word Help | |||
Mailmerge from Excel my numbers do not stay as 2 decimals. Help | Mailmerge |