View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Heather Fabries Heather Fabries is offline
external usenet poster
 
Posts: 5
Default Excel Date and Time not merging correctly to word

I am using an excel spreadsheet to merge date and time to a Word letter. The
date format is set up in excel as Thursday, December 20, 2007 and the time as
7:15 AM. I did this through 'Format Cells". However, when I pull it over to
Word through the mail merge, it is showing the date that is seen in the
format bar - 12/19/2007 and the time 7:15:00 AM. How do I get it to pull
over the value in the cell and not what is in the formula bar?

I tried this in both Excel and Word 2003 and 2007.

Thank you.
Heather Fabries