change numbers to date

[Guest]

how to change a column of numbers to a date like
2411 to 24/11/05
3011 to 30/11/05

 

[Bill Ridgeway]

The formula is -

=value(left(a2,2)&"/"&right(a2,2)&"/2005")

in a cell that has been formatted to dd/mm/yyyy

Regards.

Bill Ridgeway
Computer Solutions

 

[Laura \( '_' \)]

Hiya Abe,

Format
Style
Modify
Date

Then select the style you want

Hope that helps
--
@---}--
Laura.....
Liverpool, England

"Do you know where you're going to?"

 

[Niek Otten]

That doesn't work for 1-digit days.

=DATE(2005,MOD(A1,100),INT(A1/100))