Prev: Format Date Filter Problem
Next: Conditional Formatting Help
From: "David Biddulph" groups [at] on 20 Apr 2010 19:44
.... but only if your Windows Regional Options (in Control Panel, not in
Excel) are set to mddyyyy, rather than dmmyyyy.
--
David Biddulph


"Jacob Skaria" <JacobSkaria(a)discussions.microsoft.com> wrote in message
news:83A7EB10-68FC-4432-9C86-702A6A232780(a)microsoft.com...
> Forgot to mention...If you want to convert that to a valid date apply the
> below formula to a column near by and format to date....
>
> =--TEXT(A1,"00\/00\/0000")
>
> --
> Jacob (MVP - Excel)
>
>
> "Katerinia" wrote:
>
>> Text in Column E is a date mddyyyy
>> I need to calculate the age but the text format of this date is throwing
>> off
>> the number. Any suggestions
>>
>> 8241938
>> 4121939
>> 8071965
>> 2251950
>> 2101940
>> 12201964
>> 1241980
>> 5311961
>> 3281982
>> 3021967
>> 9171961
>> 10211977
>>
>> --
>> Excel isnt just a program its a metaphor for life. Sometimes it is easy
>> and
>> boring.. sometimes it is a little challenging and great.. then there are
>> days
>> it will drive you absolutely INSANE.


First  |  Prev  | 
Pages: 1 2
Prev: Format Date Filter Problem
Next: Conditional Formatting Help