dates in excel show up as text numbers in merge with word doc

R

relo

I have five columns with dates in my spread sheet, all are formatted with the
custom function=mm/dd/yy. ( Have also tried the date function 00/00/00). When
I input the dates to Excel they work fine and look like they should look.
However when I try to mailmerge these dates into a word doc two of the
columns work OK. But the dates in the other three colunms come out as a
number. Example the date 09/14/07 becomes 39339 in the word doc. The date
06/17/07 becomes 39250 etc. I normally have the auto filter turned on and I
have tried with it off. It resides on my "P" personnal drive on my networked
computer. I'm using Excel 2003. Any thoughts????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

separating date and time 5
Enclosures with word-doc 1
Date/Time 1
Need help with converting CUSTOM format/TEXT format to DATE format 6
Edit Date 1
Matching dates to cells 8
Time Sum in Excel 1
text to date..! 4

Top