Trailing zeros cut off on mail merge from Excel

[alant]

When I merge a doucument from Excel 2002 into Word 2003, the field containing
currency (in the format £22.22) loses its last zero after merging. If the
original in Excel was £23.40 it becomes £23.4. However if it was £23.42 then
it merges correctly. Does anyone know how to prevent the 0 being lost?

 

[alant]

Sorry there's a typo in the above -it should read Word 2002 (and it should be
document)
..

 

[Doug Robbins]

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm


--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP