Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Number formats from Excel into mail merge
A colleague has a list of numbers in an Excel spreadsheet to merge into a
letter. They want to preserve the comma and 2 decimal places in the source Excel file, but when mail merge is run the number is converted to text and the formatting is lost in the letter. Is there any way in Excel or Word to preserve the format (to save retyping all the numbers in text format)? (for Excel & Word 2003) Thanks -- R Ormerod |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Number formats from Excel into mail merge
See 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 # R Ormerod wrote: A colleague has a list of numbers in an Excel spreadsheet to merge into a letter. They want to preserve the comma and 2 decimal places in the source Excel file, but when mail merge is run the number is converted to text and the formatting is lost in the letter. Is there any way in Excel or Word to preserve the format (to save retyping all the numbers in text format)? (for Excel & Word 2003) Thanks |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Number formats from Excel into mail merge
See the following page of fellow MVP Graham Mayor's website
http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "R Ormerod" wrote in message ... A colleague has a list of numbers in an Excel spreadsheet to merge into a letter. They want to preserve the comma and 2 decimal places in the source Excel file, but when mail merge is run the number is converted to text and the formatting is lost in the letter. Is there any way in Excel or Word to preserve the format (to save retyping all the numbers in text format)? (for Excel & Word 2003) Thanks -- R Ormerod |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with using Excel data in a Word mail merge | Microsoft Word Help | |||
to print mail merge from excel | Mailmerge | |||
In mail merge from an excel source the number fields are too long | Mailmerge | |||
Format Fractions in Mail Merge. | Mailmerge | |||
Keeping number formats (eg. 5.15%) in Excel/Word Mail Merge | Mailmerge |