Excel Date Settings

  Large JD 11:33 18 Jan 2010
Locked

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

JD

  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

JD

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

Elsewhere on IDG sites

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 ?