Covert Number to date
Select the column with the "dates", do datatext to columns, click next
twice, under column data format select Date and from dropdown select YMD and
click finish
--
Regards,
Peo Sjoblom
"Newbee" wrote in message
...
I have a spreadsheet with 20071123 is in number format. I am trying to
covert it so that excel will see those numbers as a date. It is not text
but
in number format. How do I change this to make it read 11/23/2007
|