Excel & birthdays

How do I get excel to accept a birthdate by entering keystrokes 09201950 into
a cell?

Look here
http://www.rondebruin.nl/qde.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Norma" <Norma@discussions.microsoft.com> wrote in message news:D68F1D36-5C5A-4803-9DFF-9891BD744BC0@microsoft.com...
> How do I get excel to accept a birthdate by entering keystrokes 09201950 into
> a cell?

Go into Format --> Cell --> Number tab, and select 'Custom'. In the box
labelled "Type", you should be able to type in MMDDYYYY.

"Norma" wrote:

> How do I get excel to accept a birthdate by entering keystrokes 09201950 into
> a cell?

On Wed, 10 Aug 2005 17:17:02 -0700, ellmcg <ellmcg@discussions.microsoft.com>
wrote:

>Go into Format --> Cell --> Number tab, and select 'Custom'. In the box
>labelled "Type", you should be able to type in MMDDYYYY.
>
>"Norma" wrote:
>
>> How do I get excel to accept a birthdate by entering keystrokes 09201950 into
>> a cell?

That only affects how the contents of the cell are displayed. It will not
allow the OP to enter a date in that format.


--ron