Just spotted an annoying thing!
-
In XL, type in a date, say 20th Dec. But Type it in this format... 20/12 and owing to the format I have on the screen it comes out as 20/12/2009. OK, BUT I WANT 20/12/2008! It will not automatically set to the PREVIOUS 20th of Dec! I just noticed this because I wanted an analysis of data and had none to analyse! Easily fixed, but there is no generic way of setting this.
------------------------------------ "The greatest tragedy in mankind's entire history may be the hijacking of morality by religion" Arthur C Clarke
I've also found this annoying but for a different reason, I have a produce that is called a 20/12 .... and every time I enter it into excel it converts it to a data ..especially when I paste. It's getting annoying!
-
In XL, type in a date, say 20th Dec. But Type it in this format... 20/12 and owing to the format I have on the screen it comes out as 20/12/2009. OK, BUT I WANT 20/12/2008! It will not automatically set to the PREVIOUS 20th of Dec! I just noticed this because I wanted an analysis of data and had none to analyse! Easily fixed, but there is no generic way of setting this.
------------------------------------ "The greatest tragedy in mankind's entire history may be the hijacking of morality by religion" Arthur C Clarke
Dave, every system I've ever worked with that permits dd/mm (or, in the US, mm/dd) has always assumed that the current calendar year will be used, unless it is a system specifically designed to use a system-specific "current year". I suggest increasing your coffee intake...either that, or design a macro to format dd/mm as you like it, then assign it to the key of your choice. Thus, you will save us the annoyance of feeling slightly guilty for our urge to laugh loudly and scornfully at complaints like this. On the other hand (with gleeful scorn, or scornful glee) :laugh::laugh::laugh::laugh::laugh: