Reply
 
Thread Tools Display Modes
  #1   Report Post  
alant
 
Posts: n/a
Default Trailing zeros cut off on mail merge from Excel

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?
  #2   Report Post  
alant
 
Posts: n/a
Default

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

  #3   Report Post  
Doug Robbins
 
Posts: n/a
Default

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
"alant" wrote in message
...
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
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge with attachments AS Mailmerge 5 April 9th 05 09:49 AM
How do I set sup a mail merge from Excel to Word if the system ca. db@kingassoc Mailmerge 2 December 15th 04 08:07 PM
Include linked graphs from Excel during mail merge? dhschick Mailmerge 1 December 14th 04 01:02 AM
Mail merge error occurs when filtering Excel data source Dave Mailmerge 1 December 2nd 04 10:46 PM
How do you set up a label mail merge with Excel as source in 2003. Psychic Mom Mailmerge 1 November 27th 04 03:03 PM


All times are GMT +1. The time now is 02:44 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"