Number or text to date

[Nabellfl]

I need to change 20020102 into the date format 01/02/2002. Any suggestions?

 

[Toppers]

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

assuming A1 is yyyymmdd

HTH

 

[Dave Peterson]

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]

Worked greeat. Thank you.

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.