| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
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 |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Blank date fields in Excel merging with Date/Time | Mailmerge | |||
| HELP! SOMEBODY, anybody! Merging Excel date into Word 2003 templ | Mailmerge | |||
| Excel date format merging to Word XP version | Mailmerge | |||
| When merging date into Word 2003 from Excel, how do I keep the fo. | Microsoft Word Help | |||
| Date issue merging from Excel field in Date format to Word | Mailmerge | |||
Threaded Mode