| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date formating
I needed to data entry pages and pages of dates, how can I format a dates
without typing the (/) symbol, typing this symbols really slows me down. For example: 102006 (for october 20, 2006), I wanted this to show as 10/20/06 just by typing 102006. Why do I get 4/11/79 as the answer when using date format (3/14/01) on the format tab menu? Please help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to return a value between date ranges | Excel Worksheet Functions | |||
| Another Date issue. | Excel Worksheet Functions | |||
| Help with date formating when export to Word | Excel Discussion (Misc queries) | |||
| NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
| Formating decimal and date | Excel Worksheet Functions | |||
Threaded Mode
