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-
Bookmarks