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

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017