[R Ormerod]

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

[Graham Mayor]

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

[Doug Robbins - Word MVP]

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