Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
T created a spreadsheet with a Date column and want the format to be 02/19/06
but I want to be able to type in the six digits without typing in the slashes. Typing in today's date of 021906, you get 12/22/59, the 21,906th day of (last) century. Is these a way to format the cell to be able to type just 6 digits and get the correct date? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Conditional Formatting a Date Question | Excel Discussion (Misc queries) | |||
Excel Date Formula Question | Excel Discussion (Misc queries) | |||
New excel user question: Incase of tie, select latest date | New Users to Excel | |||
Excel 2000 Date Question | Excel Worksheet Functions | |||
Date question | Excel Programming |