LinkBack Thread Tools Search this Thread Display Modes
  #11   Report Post  
Old June 29th 09, 04:13 AM posted to microsoft.public.excel.misc
external usenet poster
First recorded activity by ExcelBanter: Aug 2006
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
news Dave - I thought your suggestion to use dd/mmmm/yyyy was a misprint - how
the numeric month eg 01 for January through to 12 for December be
by four characters? I think I must be missing something... I want the
to look like this: 11/06/2009 (for 11 June 2009).


Dave Peterson

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I change the default header date format in Excel 2007? Jazzman721 Excel Worksheet Functions 3 June 12th 09 10:35 PM
How do I change date yyyymmdd to a Excel-supported date format? dan Excel Worksheet Functions 4 July 6th 08 11:05 PM
Change satellite julian date format YYYYDDDHHMMSS to excel date ti putley Excel Discussion (Misc queries) 1 January 11th 08 06:12 PM
*.csv format change if .xlt save as .csv in Excel 2007 Khayae Excel Discussion (Misc queries) 1 December 14th 07 12:54 PM
How to change cond. format icons in EXCEL 2007? PapaBear Excel Worksheet Functions 0 May 25th 06 05:20 PM

All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017