Number or text to date
Worked greeat. Thank you.
"Dave Peterson" wrote:
If you have a whole column of this stuff, you can select that range
data|text to columns
fixed width (but erase any lines that excel guessed)
choose date (ymd or ydm -- difficult to guess with your sample)
And finish up the wizard.
Then you can format those dates anyway you want via:
format|Cells|Number tab.
Nabellfl wrote:
I need to change 20020102 into the date format 01/02/2002. Any suggestions?
--
Dave Peterson
|