Data Types

A

Allison McCoy

I am having trouble converting a data type on a file that I received. It is supposed to display the date as mm/dd/yyyy, but it is formatted as a number. When I try to change it to a date/time format, it does not convert correctly. Does anyone know how to fix this?

Thanks
 
G

Guest

Hi

Give us an example of what your number looks like now ie is it 23072004,
07232004 or 20040723?

--
Andy.


Allison McCoy said:
I am having trouble converting a data type on a file that I received. It
Click to expand...
is supposed to display the date as mm/dd/yyyy, but it is formatted as a
number. When I try to change it to a date/time format, it does not convert
correctly. Does anyone know how to fix this?
 
D

Dave Peterson

If all the days are entered as two digits: 2011954 (for Feb 1, 1954), you could
use a helper cell (or helper column).

Put a formula like:
=DATEVALUE(TEXT(A1,"00\/00\/0000"))
format it as a date
Edit|copy
Edit|paste special|values
(over the original range???, and delete the helper column)
 
Top