Win. Mob 5.0 Excell date problem

  Baz48 17:56 23 Dec 2006
Locked

I have transfered an Excell doc. to my PDA but a column of dates has been transposed to the US type e.g. from 23/12/06 to 12/23/06.

Is there a way to change this?

System is Windows Mobile 5.

  VoG II 18:05 23 Dec 2006

I don't know about PDAs but on PCs Excel's treatment of dates is based on the settings in Control Panel, Regional and Language Options.

  Baz48 20:00 23 Dec 2006

No control panel on the PDA and very little control in Excell. You don't even seem to be able to open a new file from within the program, only by double clicking the file in explorer.

  VoG II 20:03 23 Dec 2006

Do you have any control over regional settings? Something like 'Locale' for example.

  Baz48 20:09 23 Dec 2006

I've just noticed that the date is in the US format on the screen saver when the PDA is docked in the Activesync cradle, so it looks like a basic set up problem. I will have a hunt round for some kind of setup.

  Baz48 20:18 23 Dec 2006

Found a "regional settings" hidden away and it was set to English US. Sorry for the trouble!

  VoG II 20:21 23 Dec 2006

No problem and thanks for the feedback.

Have a great Christmas!

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

Elsewhere on IDG sites

Fujitsu Lifebook P727 laptop review

Microsoft Paint set to die after 32 years

Mac power user tips and hidden tricks

Comment désactiver la saisie intuitive et paramétrer votre clavier ?