I don't own a PDA, so I don't know the answer.

But have you checked the regional settings on your pc?

I'd format that date in an unambiguous format (dd-mmmm-yyyy) and then see what
happens on the PDA.

You may want to include the PDA that you're using and what software you're
running on that. It may help others give you an answer.

browniebodrum wrote:

In my Excel 2007 files (on my laptop) I use the following date format:
dd/mm/yyyy but I've recently noticed that when I open the file on my PDA, the
format is changed to mm/dd/yyyy. I've checked 'Regional Settings' on my PDA
and the date format is set to dd/mm/yyyy there. So what causes the switch?
I'm running Vista Business SP2 and Office 2007 on the laptop and WM 6.1 on
the PDA which is a Sprint HTC Mogul. Suggestions and ideas gratefully
received.

--

Dave Peterson