Reply
 
Thread Tools Display Modes
  #1   Report Post  
BW
 
Posts: n/a
Default Format Excel data for merging in Word

Hi - I'm doing a mail merge to pull tax-deductable amounts (about 2500
records) from Excel into a Word form letter, and the data I'm merging refuses
to look the way I want it to (expressed as currency in the Word doc).

Obviously I want the amounts that come over to appear as $xx.xx. The data I
received was exported from a SQL query, and in raw form it appeared sometimes
with 6 or 8 numbers past the decimal (i.e. xx.xxxxxxxx). I've tried many
different things, such as:

1) Formatting the cells as currency with two decimal places. When merged,
it still appeared with many numbers, or if it was a round number like $10.60,
it would appear as "$10.6".

2) I tried cutting all the data from the spreadsheet, pasting into Notepad,
and then cutting from there back into Excel so as to remove any formatting.
When merged, still appeared as above.

3) Finally, saving as a .csv, and then opening again in Excel. Same thing as
1 and 2 above when I tried to merge it. Not sure what I thought that would
accomplish, but I'm running out of ideas. Maybe there is some field
formatting I'm not familiar with that could solve it?

Any help would be wonderful! Thanks -
  #2   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
"BW" wrote in message
...
Hi - I'm doing a mail merge to pull tax-deductable amounts (about 2500
records) from Excel into a Word form letter, and the data I'm merging
refuses
to look the way I want it to (expressed as currency in the Word doc).

Obviously I want the amounts that come over to appear as $xx.xx. The data
I
received was exported from a SQL query, and in raw form it appeared
sometimes
with 6 or 8 numbers past the decimal (i.e. xx.xxxxxxxx). I've tried many
different things, such as:

1) Formatting the cells as currency with two decimal places. When merged,
it still appeared with many numbers, or if it was a round number like
$10.60,
it would appear as "$10.6".

2) I tried cutting all the data from the spreadsheet, pasting into
Notepad,
and then cutting from there back into Excel so as to remove any
formatting.
When merged, still appeared as above.

3) Finally, saving as a .csv, and then opening again in Excel. Same thing
as
1 and 2 above when I tried to merge it. Not sure what I thought that would
accomplish, but I'm running out of ideas. Maybe there is some field
formatting I'm not familiar with that could solve it?

Any help would be wonderful! Thanks -



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
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 10:50 PM
Excel worksheet in Word linked text boxes Eduardo Oliveira Page Layout 0 January 5th 05 11:23 PM
Word Field Codes in Excel data file mranz Mailmerge 7 December 11th 04 09:02 AM
formatting links from excel into word (extra line feeds) JGT Microsoft Word Help 1 December 9th 04 11:01 AM
Linking Excel data to tables in Word KSit Tables 3 November 26th 04 09:36 PM


All times are GMT +1. The time now is 04:20 PM.

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

About Us

"It's about Microsoft Word"