Excel serial date formats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BarbH - 19 Aug 2005 23:25 GMT

I am merging an Excel file into a Word document. There are serial dates in my
Excel file, and the formatting doesn't transfer to Word. Is there somewhere
that I can set up my Word file to format the numbers as dates? Or can I
convert the numbers to dates within Excel before I complete the merge?

Reply to this Message

Anne Troy - 20 Aug 2005 00:16 GMT

Barb: Serial dates are, for instance, 38584, which is today. THAT is what
you want to show in Word? I suspect it's not, and you just need the usual
formatting guidance here:
http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm
************
Anne Troy
www.OfficeArticles.com

>I am merging an Excel file into a Word document. There are serial dates in
>my
> Excel file, and the formatting doesn't transfer to Word. Is there
> somewhere
> that I can set up my Word file to format the numbers as dates? Or can I
> convert the numbers to dates within Excel before I complete the merge?

Reply to this Message

BarbH - 20 Aug 2005 01:33 GMT

Perfect! I did a search and couldn't find anything.Thank you for getting back
to me so quickly and with such great additional information. This has been an
excellent experience for me! Thanks again.

> Barb: Serial dates are, for instance, 38584, which is today. THAT is what
> you want to show in Word? I suspect it's not, and you just need the usual
[quoted text clipped - 10 lines]
> > that I can set up my Word file to format the numbers as dates? Or can I
> > convert the numbers to dates within Excel before I complete the merge?

Reply to this Message

macropod - 20 Aug 2005 04:20 GMT

Hi Barb,

Another way of dealing with serial dates can be found in the attachment at:
http://www.wopr.com/cgi-bin/w3t/showthreaded.pl?Number=249902

Unless you're working with a data source that is limited to serial dates,
you'd probably be better off with the solution Anne pointed you to, though.

Cheers

> Perfect! I did a search and couldn't find anything.Thank you for getting back
> to me so quickly and with such great additional information. This has been an
[quoted text clipped - 3 lines]
> > you want to show in Word? I suspect it's not, and you just need the usual
> > formatting guidance here:

http://www.officearticles.com/word/merge_field_formatting_in_microsoft_word.htm

> > ************
> > Anne Troy
[quoted text clipped - 6 lines]
> > > that I can set up my Word file to format the numbers as dates? Or can I
> > > convert the numbers to dates within Excel before I complete the merge?

Reply to this Message

Rate this thread: