Converting a date from serial back to mm/dd/yyyy hh:mm:ss

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anthony - 28 Dec 2006 19:09 GMT

I have a spreadsheet that insists on only showing the serial value of
the date. For example the cell displays as "6/15/2005 9:58:08 AM" but
in the formula bar lists itself as "6/15/2005 9:58:08 AM".

If I try to go to Format-->Cells and set the formatting to a different
date setting it does not change how it appears and prints inside of the
spreadsheet.

Anybody ever run into this problem?

Reply to this Message

orbii - 29 Dec 2006 00:36 GMT

i think in Excel 2007 there's a DATEVALUE function that would allow you to
convert any date formatted as text to be converted back to a serial number
reckon by Excel as dates value. But remember to format that cell as a date
also. Hope this helps...

orbii

>I have a spreadsheet that insists on only showing the serial value of
> the date. For example the cell displays as "6/15/2005 9:58:08 AM" but
[quoted text clipped - 5 lines]
>
> Anybody ever run into this problem?

Reply to this Message

Rate this thread: