View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
browniebodrum browniebodrum is offline
external usenet poster
 
Posts: 28
Default Change of date format when syncing Excel 2007 to Excel Mobilw

Sorry I had no time recently to work through this methodically, but I've
attempted to do so now and here are the results:

Test 1: Format in PC version: Custom, dd-mmmm-yyyy -
Format on pda unchanged after sync

Test 2: Format in PC version: Date, *14/03/2001 - Format on pda changed to
mm/dd/yyyy after sync

Test 3: Format in PC version: Date, 14/03/2001 - Format on pda unchanged
after sync

Test 4: Format in PC version: Custom, dd/mm/yyyy - Format on pda changed
to mm/dd/yyyy after sync

Test 5: Format in PC version: Custom, dd/mm/yy - Format on pda unchanged
after sync

Regional settings (for all tests above): On the PC, the Locale/location =
English/UK, and Control Panel Regional & Language Options = English (UK) .
On the PDA the Regional settings are set to English (United Kingdom) and the
short date format is 28/06/09 or dd/MM/yy.

So now I know how to AVOID the format changing but I'd still like to
understand why the custom format 'dd/mm/yyyy' gets changed when I sync,
whereas the custom format 'dd/mm/yy' (with a two-digit year) does not.

Device: Sprint HTC Mogul 6800, WM6.1
PC: Windows Vista Business (32-bit) SP2, Outlook 2007, Windows Mobile
Device Centre 6.1.6965


"Dave Peterson" wrote:

Wouldn't it take less time to actually change the format, test it, see the
results and change it back?



browniebodrum wrote:

Thanks, both, but I think we're getting a bit off the subject. The dates are
not ambiguous to me in this particular case, so there is no need for me to
change the format to something that might be clearer to see for anyone else
under different circumstances. I understand what you are saying but in this
particular case, there's only me using this file, and the dates in the
spreadsheet are consecutive dates in May and June 2009 so it's not difficult
to see what they really are. I'm not confused about the format and it's not
ambiguous to me. The point is, as per my original post, the format is set to
dd/mm/yyyy in the laptop version (as is the default in regional settings) BUT
syncing with the mobile (which also has the dd/mm/yyyy format as the default
in its regional settings) changes it to mm/dd/yyyy. Does anyone know why?



"David Biddulph" wrote:

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).




--

Dave Peterson