| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Date in Excel merges in number format (3/9/07 instead of March 9,
I have an Excel spreadsheet that has a column formatted as DATE with the
FORMAT being March 9, 2007 and it shows up correctly in the spreadsheet, but when merged the date shows up as 3/9/07. How can I correct this so it merges as March 9, 2007? |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Date in Excel merges in number format (3/9/07 instead of March 9,
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Beach Lover" wrote in message ... I have an Excel spreadsheet that has a column formatted as DATE with the FORMAT being March 9, 2007 and it shows up correctly in the spreadsheet, but when merged the date shows up as 3/9/07. How can I correct this so it merges as March 9, 2007? |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Date in Excel merges in number format (3/9/07 instead of March
Thanks. I actually found a way to resolve the problem while in Excel.
Create a new column and use the formula: =TEXT(B2, "mmmm dd, yyyy") "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Beach Lover" wrote in message ... I have an Excel spreadsheet that has a column formatted as DATE with the FORMAT being March 9, 2007 and it shows up correctly in the spreadsheet, but when merged the date shows up as 3/9/07. How can I correct this so it merges as March 9, 2007? |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date Format from Excel Field | Mailmerge | |||
| How do I import & format to fit excel date into word | Page Layout | |||
| HELP!!! Date not in correct UK format when merging from Excel | Mailmerge | |||
| Date format changing on mrg from Excel to Word | Mailmerge | |||
| Date issue merging from Excel field in Date format to Word | Mailmerge | |||
Hybrid Mode
