I have a spreadsheet created in Excel 2003 which has a cell formatted as a Custom date (mmm-yy).All our users seem to find this works, except for some of our guys in Sweden. They are reporting that any date entered changes the year to 05 (example. Mar-03 becomes Mar-05)The only way I have been able to emulate anything close to this error is shown below.Example, by entering:'02/03' (for Feb 2003) the cell shows 'Mar-05'- but I believe this is technically correct as Excel will interpret 02 as the day and 03 as the month and append the current year on, hence Mar-05.Entering '01/02/03' appears correctly as 'Feb-03'.I'm stumped as to what may be causing this. My hunch is that they are entering dates as mm/yy (although they assure me they are not).Anyone got any ideas what's happening?Thanks in advance.
It is because Excel is looking for the day, month and year... You need to change the format...
As my post mentioned, I've suspected this, but they assure me they are entering the date as either Mar-03 or 01/03/04 for example.Plus they claim that the date changes from Mar-03 to Mar-05, which is not what you would expect if they were entering dates as mm/yy.Example:02/03 would change to Mar-05They claim they are entering:Mar-03 and it is changing to Mar-05
OK... I will try this... Back in a minute...
Nothing.... I can't seem to "make" this problem....I would ask then to make a screenbump of what they are typing in and e-amil it you so you can see what they are typing...
Just tried it. If I enter 03/04 it comes up as Apr-05 But if I enter mar 04 it comes up as Mar-04.Make sure you enter the data as Month (mar) space Year (04) etc.dont forget the space.
perhaps it is something to do with the date settings in Windows regional setings, via control panel.If they have it different over there, maybe that is reflected somehow in Excel?As I say, clutching at straws!Regards,Simsy
if I enter 03/04 I get 03-Apr???Regards,Simsy
Simsy, even stranger because I formatted a whole column as Format, Cells, Custom and selected mmm-yyNow if I select a blank cell within that column and go to Format, Cells it shows up as Date (Mar-98) and not Custom anymore?
Sorry, should say I am using Excel 2000 not 2003 perhaps there is a difference.
here at work.Regards,Simsy
This thread is now locked and can not be replied to.
Xiaomi Mi Mix 2 review
What went wrong at the Designs of the Year 2017
iPhone X news: Release date, price, new features & specs
Comment utiliser Live Photos ?
© Copyright 2017 IDG UK. All Rights Reserved.