| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date formating
Check out this link for quick entry...
http://www.cpearson.com/excel/DateTimeEntry.htm Dates are stored in Excel as numbers based on the number of days elapsed since Jan 0, 1900 (known as the epoch). So when you type in 31401 that translates to 31,401 days since the epoch which is 4/11/79. -- HTH... Jim Thomlinson "chad" wrote: 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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date formating
http://xldynamic.com/source/xld.QDEDownload.html
-- Kind regards, Niek Otten Microsoft MVP - Excel "chad" <pinoyako.com wrote in message ... |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. | |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date formating
thats a nice one...good luck with your fast encoding...
"Niek Otten" wrote: http://xldynamic.com/source/xld.QDEDownload.html -- Kind regards, Niek Otten Microsoft MVP - Excel "chad" <pinoyako.com wrote in message ... |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. | |
| Reply |
| 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 | |||
Linear Mode
