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.

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

Dave - I already included that information in the original post: WM 6.1 on
the PDA which is a Sprint HTC Mogul.

As for formatting the date on the PC, it's already formatted dd-mm-yyyy and
everything works fine on there. It's only after synchronising the file with
the PDA running Excel Mobile 6.1 that the date format changes, and it ONLY
changes on the PDA version.

It might be worth mentioning that the regional preference is set to UK on
both laptop and PDA, so dd-mm-yyyy is the default date format anyway, not
mm-dd-yyyy which is the default for the US region.


"Dave Peterson" wrote:

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

Yes, you did. I didn't notice it. Sorry.

But I suggested dd-mmmm-yyyy, not dd-mm-yyyy.

What happened when you tried that?

(I still won't have a guess, though.)



browniebodrum wrote:

Dave - I already included that information in the original post: WM 6.1 on
the PDA which is a Sprint HTC Mogul.

As for formatting the date on the PC, it's already formatted dd-mm-yyyy and
everything works fine on there. It's only after synchronising the file with
the PDA running Excel Mobile 6.1 that the date format changes, and it ONLY
changes on the PDA version.

It might be worth mentioning that the regional preference is set to UK on
both laptop and PDA, so dd-mm-yyyy is the default date format anyway, not
mm-dd-yyyy which is the default for the US region.

"Dave Peterson" wrote:

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


--

Dave Peterson

Dave - I thought your suggestion to use dd/mmmm/yyyy was a misprint - how can
the numeric month eg 01 for January through to 12 for December be represented
by four characters? I think I must be missing something... I want the date
to look like this: 11/06/2009 (for 11 June 2009).

It's a temporary test. It'll show the date in an unambiguous format:

01-January-2009

Then you can actually compare/contrast the values in both platforms.

As long as I see something like 01/02/03, I'll never know if it's really a
date--and what that date really is.

After you test, you can change the numberformat to whatever you want.

browniebodrum wrote:

Dave - I thought your suggestion to use dd/mmmm/yyyy was a misprint - how can
the numeric month eg 01 for January through to 12 for December be represented
by four characters? I think I must be missing something... I want the date
to look like this: 11/06/2009 (for 11 June 2009).

--

Dave Peterson

What Dave suggested was dd-mmmm-yyyy, which gives 12-June-2009.
He explained (but you snipped) that the reason why he suggested that format
is that it is unambiguous, whereas 12-06-2009 can easily be misinterpreted.
--
David Biddulph

"browniebodrum" wrote in message
...
Dave - I thought your suggestion to use dd/mmmm/yyyy was a misprint - how
can
the numeric month eg 01 for January through to 12 for December be
represented
by four characters? I think I must be missing something... I want the
date
to look like this: 11/06/2009 (for 11 June 2009).