creating a mail merge with dates

  • Thread starter Thread starter ********Meg
  • Start date Start date
M

********Meg

hi using excel version 98 (stop laughing)

I have a field with dates. When I go to do a mail merge into a word
document those dates are getting converted or inverted. 5/1 become 1/5. It
is inconsistent but seems to happen in April and May.

When I turn the column into a text field, the dates become numbers and so I
lose my data. Is there a way to paste the values of the fields into a text
column so that the true date will work with the merge?

hope this makes sense.

Thank You.
 
Dates in column B


insert a help column and use this formula


=TEXT(B2,"mm/dd/yy")


change the date format depending on your region to your liking

copy down and paste special as values over the old values, delete help
column

--


Regards,


Peo Sjoblom
 
Back
Top