Date format using space as date separator rather than forward slash!

Can you post a snip of the following please?

Control Panel -> Clock, Language, and Region -> Region and Language

Under the formats tab click 'Additional Settings...' (post that snip)

I notice that you have "ddd" in front of the date format ("ddd dd/mm/yyy"). Try removing that as it could be what's conflicting.

Ok, i've isolated that it is indeed the "ddd" that's causing the issue as i've just tried it and all date formats in Excel (even 2010) now have spaces seperating them...

With "ddd"


Without "ddd"

It's a very strange fault (for want of a better word) so I've highlighted my findings in a new thread in the hope that someone may have found a way to work around it.

Custom Date Settings...Inconcistencies

i've found the system format uses whatever the char. is after the initial ddd as the seperator, if you use

ddd dd/mm/yyyy you get Mon 08 11 2010
ddd, dd/mm/yyyy you get Mon, 08,11,2010

dddd dd/mm/yyyy similarly gives Monday 08 11 2010
dddd, dd/mm/yyyy gives Monday, 08,11,2010

unfortunately ddd/ .... gives Mon/ 08/11/2010.

in excel 2007, using ddd dd/mm/yyyy system setting, i could force cell formatting to the desired one by using the custom format of ddd dd/mm/yyyy, even if the date format was invalid.

my task scheduler dates show as Mon 08/11/201 as the string doesn't fit the space by one char. using the short year would fix that, ie. Mon 08/11/10.

to avoid ambiguity i always set my date string to military format dd mmm yyyy , giving 08 Nov 2010 which is unambiguous between the UK and my friends & relatives in the US.