Data Types

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002: How to make the date format uniform ? 1
Convert dates stored as text 2
counting records by month and year / date format issues 1
Formatting Dates from Text to Numbers 2
Changing date to eliminate day in format mm/dd/yyyy 1
cell format - not automatically taking effect 4
Date automatically swaps 6
Date format changes in mail merge using Excel worksheet as data 2

Back
Top