| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Eliminate Excel date formatting
When I enter "Jan 03" meaning the month of January 2003, the program
automatically enters 3-Jan and assumes I mean January 3, 2006. I have changed the number format of the entire column to General and have even tried changing it to the date format "Mar 01" to no avail. How do I prohibit Excel from ASSUMING what I want to enter and just let me enter what I want? Also, is there any way for excel to calculate times, like 22 minutes 15 seconds plus 8 minutes 12 seconds? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel date field link to Word | Excel Discussion (Misc queries) | |||
| Excel 2002 Date Formatting | Excel Discussion (Misc queries) | |||
| Excel enters date as a text format | Excel Discussion (Misc queries) | |||
| Excel formula with date constraints | Excel Discussion (Misc queries) | |||
| Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
Threaded Mode
