| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date Format
The digits typed do not match the output, I wonder why.
I also tried to type 000000 and that defaulted to Jan1 1900. then I input 010101 which results into 8/27/27 , for 8/27/1927. this really baffles me, as I tried to Clear All to no avail. thanks for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
| 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) | |||
Threaded Mode
