the date on excel?

  GEEKSTA 16:53 19 Nov 2007
Locked

At school i have some work on microsoft excel with dates, eg 14/1/2007 (with the date first). Now when i save into a memo stick and bring it home and load it up on my excel (the same version) the dates are shown as 1/14/2007 (with the month first).

Why had it changed the format??
How do i change it back with out putting in the dates again??

  VoG II 16:58 19 Nov 2007

Check the settings in Control Panel > Regional and Language Options.

  GEEKSTA 17:04 19 Nov 2007

THANKSSSSSS!!!
it worked, it was just on english united states, so i changed it to english UK

thankss

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

Elsewhere on IDG sites

Alienware 17 R4 2017 review

Is this the future of VR and AR?

Best iPad buying guide 2017

Comment regarder le Bureau des L├ęgendes en ligne ?