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" <abe@discussions.microsoft.com> wrote in message
news:43B9BF48-262E-42BA-AE63-F8AE44834BC4@microsoft.com...
> 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" <info@1001solutions.co.uk> wrote in message
news:dmjq09$duq$1@newsg2.svr.pol.co.uk...
> 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" <abe@discussions.microsoft.com> wrote in message
> news:43B9BF48-262E-42BA-AE63-F8AE44834BC4@microsoft.com...
>> 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" <abe@discussions.microsoft.com> wrote in message
news:43B9BF48-262E-42BA-AE63-F8AE44834BC4@microsoft.com...
> how to change a column of numbers to a date like
> 2411 to 24/11/05
> 3011 to 30/11/05