| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel & birthdays
How do I get excel to accept a birthdate by entering keystrokes 09201950 into
a cell? |
|
#2
|
|||
|
|||
|
Look here
http://www.rondebruin.nl/qde.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Norma" wrote in message ... How do I get excel to accept a birthdate by entering keystrokes 09201950 into a cell? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
On Wed, 10 Aug 2005 17:17:02 -0700, ellmcg
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| "Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
| Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| Excel error - Startup (and Acrobat PDFMaker) | Setting up and Configuration of Excel | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Linear Mode
