Excel Date Settings

  Large JD 11:33 18 Jan 2010

I have noticed recently that when i use excel and imput a date into a cell, the way in which the date is displayed has change!!

Should read 18/1/2010

But reads 1/18/2010

I have tried changing the cell properties which always shows English(united states) as the default. But the next time i try to input a date the same problem

Also, another program Sliq invoicing, is doing a similar thing.

Not sure where to look next to correct this problem!!

Thanx in advance!!


  VoG II 11:57 18 Jan 2010

Take a look in Control Panel > Regional and Language Options.

  Large JD 12:23 18 Jan 2010

As easy as that!!

Many Thanx


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

Elsewhere on IDG sites

Huawei MateBook X Pro review

8 digital brands that designed custom typefaces to save millions

How to speed up a slow Mac

Comment résoudre des problèmes d’impressions ?