change numbers to date
 

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

change numbers to date
 

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

"abe" wrote in message
...
how to change a column of numbers to a date like
2411 to 24/11/05
3011 to 30/11/05

change numbers to date
 

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?"
"abe" wrote in message
...
how to change a column of numbers to a date like
2411 to 24/11/05
3011 to 30/11/05

change numbers to date
 

That doesn't work for 1-digit days.

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

--
Kind regards,

Niek Otten

"Bill Ridgeway" wrote in message
...
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

"abe" wrote in message
...
how to change a column of numbers to a date like
2411 to 24/11/05
3011 to 30/11/05