G
Guest
how to change a column of numbers to a date like
2411 to 24/11/05
3011 to 30/11/05
2411 to 24/11/05
3011 to 30/11/05
B
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
=value(left(a2,2)&"/"&right(a2,2)&"/2005")
in a cell that has been formatted to dd/mm/yyyy
Regards.
Bill Ridgeway
Computer Solutions
L
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?"
Format
Style
Modify
Date
Then select the style you want
Hope that helps
--
@---}--
Laura.....
Liverpool, England
"Do you know where you're going to?"
N
Niek Otten
That doesn't work for 1-digit days.
=DATE(2005,MOD(A1,100),INT(A1/100))
=DATE(2005,MOD(A1,100),INT(A1/100))