At 21:12 01/08/2007 +0000, Jonathon Blake wrote:
Brian Barker wrote:
> The simplest way out of this is to do what is normally done: to enter
> the dates *as dates*, e.g. as 7/7/07 or 7-7-07 or 7.7.07. (These all
Even simpler is to configure date as YYYYMMDD, so you just
enter 20070707, or 19950505.
Well, it would be simpler - if only it worked! If I format a cell as
YYYYMMDD and type 20070707 into it, what gets displayed is -86850922
- that's 22 September minus-8685. The cell will happily display
20070707, but only if what I enter is itself formatted as a date -
something like 07/07/07 or 7-7-7 (and then this is interpreted as
day/month/year - which is the default order in my locale - not in the
year-month-day order of the cell format).
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
