change numbers to date

[abe]

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

"abe" <[email protected]> wrote in message
news:[email protected]...
> how to change a column of numbers to a date like
> 2411 to 24/11/05
> 3011 to 30/11/05

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

[Niek Otten]

That doesn't work for 1-digit days.

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

--
Kind regards,

Niek Otten

"Bill Ridgeway" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> how to change a column of numbers to a date like
>> 2411 to 24/11/05
>> 3011 to 30/11/05
>
>