Problems mail merging MS Word with Excel

[skbark]

Hello,

I have a Word document that is set up to mail merge with one of my Excel spreadsheets. All the fields look as they should. However, when I do the merge, some of the fields lose the formating they had in my Excel document. (i.e. the "Effective Date" field should read December 15, 2007 (it does in my spreadsheet) but, once I mail merge with Word, it reads 12/15/2007.)

This is also happening with a currency field that should not have any decimal places. The spreadsheet shows what I want, but when I mail merge to Word, it suddenly has the decimals added.

Has anyone run into this problem? Can you help? I just want my mail merge fields in Word to bring over EXACTLY what my Excel sheet shows.

Thanks in advance for any help offered.
Sandra

 

[NateO]

Hello,

Format your numeric data to text, one way, or another.

See the following:

http://www.mrexcel.com/board2/viewtopic.php?p=1396095#1396095

Also, there are Worksheet functions to do this, e.g.,

=TEXT(A1,"mmmm dd, yyyy")

Also, check out the Fixed() function. :wink:

 

[skbark]

Oh WOW!!!! Thank you, thank you, THANK YOU!!! I've spent all day on this issue. It was driving me crazy. Your suggestions really helped.

Thank you again!
Sandy
www.sandra.barkevich.com

 

[NateO]

You are welcome, Sandy.

 

[Macropod]

Hi Sandy,

For more info on using the date switch on a merge field - see
http://www.gmayor.com/formatting_word_fields.htm

Cheers