Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Sherry
 
Posts: n/a
Default Numbers reformatting during mail merge

I am doing a mail merge from an Excel document. The
field in the document is an hourly salary amount, so it
is formatted as a number with 2 decimals. When I set up
the merge to Word, however, it shows the field as having
15 decimals. I cannot change the format once it is in
Word. I have tried using several different formats while
it is still in Excel, before the merge, including a
custom format, but no matter how it shows formatted in
Excel, when it is merged into Word the 15 decimal places
appear. Any ideas?

Thanks,
Sherry
Rome, Georgia
 
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
How do I eliminate numerous "Mail Merge..." under my tool bar? JulieMae Microsoft Word Help 2 January 9th 05 10:45 PM
mail merge problem - "Word found locked fields during the update.. zgaryt Tables 1 January 9th 05 01:04 PM
mail merge to MAPI as a PDF attachment MikeG Microsoft Word Help 1 December 13th 04 02:12 AM
Mail Merge - Date Format Kilinski Microsoft Word Help 0 December 7th 04 01:13 PM
How do I mail merge when only merge document is shown in tools? DaveAS Microsoft Word Help 2 December 1st 04 03:45 PM


All times are GMT +1. The time now is 06:35 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"