Dates showing as serial number

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom Baxter - 18 Jul 2007 16:34 GMT

I have an excel sheet that has all the dates showing as serial numbers. For
example... 8/24/2007 shows as 39318 and 6/27/2007 shows as 39260. I have
tried changing the format of the cells but it stays as the number and change
to the date. Help please.

Reply to this Message

Dave Peterson - 18 Jul 2007 17:23 GMT

Tools|Options|View tab|uncheck formulas.

> I have an excel sheet that has all the dates showing as serial numbers. For
> example... 8/24/2007 shows as 39318 and 6/27/2007 shows as 39260. I have
> tried changing the format of the cells but it stays as the number and change
> to the date. Help please.

Signature

Dave Peterson

Reply to this Message

Tom Baxter - 18 Jul 2007 17:40 GMT

Dave,
Thanks that fixed it!
-tom-

> Tools|Options|View tab|uncheck formulas.
>
> > I have an excel sheet that has all the dates showing as serial numbers. For
> > example... 8/24/2007 shows as 39318 and 6/27/2007 shows as 39260. I have
> > tried changing the format of the cells but it stays as the number and change
> > to the date. Help please.

Reply to this Message

Bernard Liengme - 18 Jul 2007 17:24 GMT

What do you mean by:but it stays as the number and change to the date?
"Stays" as a number but "change" to date????
Excel stores dates as serial numbers with 1/1/1900 as zero. It is formatting
that get them to display as dates.
best wishes

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

>I have an excel sheet that has all the dates showing as serial numbers.
>For
[quoted text clipped - 3 lines]
> change
> to the date. Help please.

Reply to this Message

Rate this thread: