Date converted to Text Number

M

Mari

If a cell is converted from a date format to text format, the date in that
cell is converted to a 5-digit number.

I would like to know how excel calculates that number so that I can reverse
that formula to figure out what dates I originally had in a bunch of cells
which now have 5-digit numbers in them, without having to change each cell
back to date format.

thanks,

m-
 
M

Mari

To answer your question:

all the cells in this particular column, i have decided, need to be in text
format. only about 10% of the cells had a date only in them (the ones with
date & text converted fine). So, I would still have to convert them to date,
then convert back to text again, and type the text date into the text
formatted cell.

my conclusion:
too much work. the dates really aren't that important anyway.... :(
but I'm glad I learned something today!

Thanks again.

m-
, - . _ , - .
\ /, " ,\ /
{ o }
Ŭ
 
G

Gord Dibben

Thanks for the feedback.

Chip has amassed a wealth of information on his site.

When you get time, browse around.


Gord

To answer your question:

all the cells in this particular column, i have decided, need to be in text
format. only about 10% of the cells had a date only in them (the ones with
date & text converted fine). So, I would still have to convert them to date,
then convert back to text again, and type the text date into the text
formatted cell.

my conclusion:
too much work. the dates really aren't that important anyway.... :(
but I'm glad I learned something today!

Thanks again.

m-
, - . _ , - .
\ /, " ,\ /
{ o }
?
Click to expand...

Gord Dibben MS Excel MVP
 
Top