| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Preserve format of data in Excel when doing a mail merge
I am using Office 2007 and am trying to do a mail merge using data from an
Excel spreadsheet. I have a 'Salary' field in Excel with the data formatted in the £ currency style e.g. £30,000.00 but when I merge the data, I lose the formatting. How can I keep the formatting in the same way as it is displayed in Excel? -- Thanks, Lou |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Preserve format of data in Excel when doing a mail merge
Word does not import Excel formatting.Use a currency formatting switch on
the field. http://www.gmayor.com/formatting_word_fields.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Louise wrote: I am using Office 2007 and am trying to do a mail merge using data from an Excel spreadsheet. I have a 'Salary' field in Excel with the data formatted in the £ currency style e.g. £30,000.00 but when I merge the data, I lose the formatting. How can I keep the formatting in the same way as it is displayed in Excel? |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mail merge and excel data | Mailmerge | |||
| Merge Excel Data into Word but NOT as a letter format? | Mailmerge | |||
| How do you preserve the data format from your data source when me. | Mailmerge | |||
| Preserve a macro-table's format when fetching data thro' merge pro | Tables | |||
| mail merge from excel that changes my format from UK to US format | Mailmerge | |||
Linear Mode
