the date on excel?

  GEEKSTA 16:53 19 Nov 07
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 07

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

  GEEKSTA 17:04 19 Nov 07

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

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

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…