| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
USING THE DATE FORMAT IN EXCEL
When i apply a date format to a cell and then type in a date......eg. 1121404
instead of giving me 12/14/04 it gives me some random date like 11/05/2265. I have changed the date format from short to long ...changed the way I enter it and even fooled with the default time setting for the computer. Is their a way to correct this problem without using a formula? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto date changing in Excel is maddening | Charts and Charting in Excel | |||
| Date format collapses diagram | Excel Discussion (Misc queries) | |||
| prevent 4/5 in a cell automatically transfer to a date format | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
| Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) | |||
Threaded Mode
