|05 Aug 2011||#1|
| || |
What is Excel Date Playing At?
I wanted to put a date into a field, but did not want it formatted. In fact it could just represent any 6 digit number; not a date at all.
So I put 050811 (today's date the British way DD MM YY)
And Excel in its infinite wisdom changed it to:
It has done this before, which is why I did not want to put " / / " in the number.
But why would a 6 digit number be formatted and changed to a totally different date?
And how can I turn it off please?
|My System Specs|
|Similar help and support threads for2: What is Excel Date Playing At?|
|Excel 2007 Date Factor||Microsoft Office|
|Separating date and time in Excel Office 2007||Microsoft Office|
|Excel 2010 question: Date 00-00-0000 (08-03-2012)(dd-mm-yyyy)||Microsoft Office|
|Excel 2007: a question about date and time manipulation||Software|
|Date questions...Excel 2007||Microsoft Office|
|Date Problem - Excel and Quickbooks||Software|
|Excel and MS-Money 2005 date and time format display issue||Microsoft Office|