Date in Excel merges in number format (3/9/07 instead of March 9,

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Beach Lover - 09 Mar 2007 12:40 GMT

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 to this Message

Doug Robbins - Word MVP - 09 Mar 2007 15:26 GMT

See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

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

>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 to this Message

Beach Lover - 09 Mar 2007 16:43 GMT

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")

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 7 lines]
> > merges
> > as March 9, 2007?

Reply to this Message

Rate this thread: