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

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

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?
 
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
 
Back
Top