I would guess you need to re-format the dates in the date column. If you highlight them and then use the format option off the menus, you might be able to choose a format that makes them come up the way they are supposed to. But I am not a "power user" either, I'm afraid, so I might be wrong.
Try changing the dates from 11/4/07 to 11/04/2007. (I appreciate that that might be a touch time consuming - there probably is an easy way of doing it but I don't know it).
You should store years as 4 digits and not 2 because if you store as 2 it has to make up what year you are talking about.
For example when you specify 07 do you actually mean 2007 or 1907? The computer has no idea, and will make (possibly incorrect) assumptions.
Hm. That year-format-thing could actually be its problem. I shall experiment. Although if it feels the need to invent numbers I wish it would invent plausible ones that don't fekk my data quite so badly...
Ah.... have given up on accounts for the eve by the time i read this but shall try it tomorrow - thankyou. why excel thinks it knows better than i what i want entered on a spread sheet i really don't know... it obviously wants to be HAL when it grows up...
may i just add that the salient feature of the above is surely - wow - someone who loves the wolseley more than i do!! and i really love it!! much respect from this london lush...x
oh my love - Wolseley are also a hardware company that have been supplying all the building materials for the oast - four-figure-sums have been spent not on wine and many good breakfasts but on bricks and timber and metal things. gods i'd be impressed if my dad had spent that much in a mayfair hotel... also jealous =)
Comments 15
But I am not a "power user" either, I'm afraid, so I might be wrong.
Reply
Format it to be dates written a particular way...
Joy! Column B with weird dates now behaving.
Pants! Column A which was invoice numbers has mysteriously turned to dates.
Fuck - Excel will now not undo this change.
*wah*
was a good idea though.
*sigh*
Reply
Reply
2) close Excel
3) open new file you saved
4) hope it saved it correctly
I'm sort of guessing here, but it sounds like Excel has got confused.
Reply
You should store years as 4 digits and not 2 because if you store as 2 it has to make up what year you are talking about.
For example when you specify 07 do you actually mean 2007 or 1907? The computer has no idea, and will make (possibly incorrect) assumptions.
Reply
Hm.
That year-format-thing could actually be its problem.
I shall experiment.
Although if it feels the need to invent numbers I wish it would invent plausible ones that don't fekk my data quite so badly...
Reply
(The comment has been removed)
why excel thinks it knows better than i what i want entered on a spread sheet i really don't know... it obviously wants to be HAL when it grows up...
Reply
Reply
gods i'd be impressed if my dad had spent that much in a mayfair hotel...
also jealous =)
Reply
how sad!
still...
we must wolseley! when it is a little chillier i think???
will you accompany me?
(sorry for my growling comment on your last post. not my place to get involved. well - the supply of cake and gin yes. beyond that....) xx
Reply
and yes, somewhen there should be breaking fast / luncheon / dining at the wolseley =)
Reply
Leave a comment