Trailing zeros cut off on mail merge from Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alant - 20 Jan 2005 15:59 GMT

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?

Reply to this Message

alant - 20 Jan 2005 16:19 GMT

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

Reply to this Message

Doug Robbins - 21 Jan 2005 01:45 GMT

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

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

Signature

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

> 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?

Reply to this Message