//some 3rd party need geo

Excel date problem, or idiot users?

  Jdoki 15:04 07 Apr 05
Locked

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.

  mattyc_92 15:06 07 Apr 05

It is because Excel is looking for the day, month and year... You need to change the format...

  Jdoki 15:15 07 Apr 05

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-05

They claim they are entering:

Mar-03 and it is changing to Mar-05

  mattyc_92 15:16 07 Apr 05

OK... I will try this... Back in a minute...

  mattyc_92 15:19 07 Apr 05

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...

  pj123 15:30 07 Apr 05

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.

  Simsy 15:33 07 Apr 05

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

  Simsy 15:36 07 Apr 05

if I enter 03/04 I get 03-Apr

???

Regards,

Simsy

  pj123 15:47 07 Apr 05

Simsy, even stranger because I formatted a whole column as Format, Cells, Custom and selected mmm-yy

Now 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?

  pj123 15:49 07 Apr 05

Sorry, should say I am using Excel 2000 not 2003 perhaps there is a difference.

  Simsy 15:58 07 Apr 05

here at work.

Regards,

Simsy

This thread is now locked and can not be replied to.

What is Google Allo? What is Google Duo? Google Allo UK release date rumours and features: Google…

1995-2015: How technology has changed the world in 20 years

These clever designs help visualise a complex intelligence tool

iOS 10 troubleshooting tips: Simple fixes for the most common iOS 10 problems, from network…