How do I get excel to accept a birthdate by entering keystrokes 09201950 into a cell?
N Norma Aug 10, 2005 #1 How do I get excel to accept a birthdate by entering keystrokes 09201950 into a cell?
E ellmcg Aug 11, 2005 #3 Go into Format --> Cell --> Number tab, and select 'Custom'. In the box labelled "Type", you should be able to type in MMDDYYYY.
Go into Format --> Cell --> Number tab, and select 'Custom'. In the box labelled "Type", you should be able to type in MMDDYYYY.
R Ron Rosenfeld Aug 11, 2005 #4 Go into Format --> Cell --> Number tab, and select 'Custom'. In the box labelled "Type", you should be able to type in MMDDYYYY. Click to expand... 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
Go into Format --> Cell --> Number tab, and select 'Custom'. In the box labelled "Type", you should be able to type in MMDDYYYY. Click to expand... 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
