Solved: What is this EXTRA bit of code - date format)

[velohead]

Hi All,

[vba]Selection.NumberFormat = "[$-C09]d mmmm yyyy;@"[/vba]
I have recorded & used the above code to format a date in VB, which it does.

It seems to work without this part......
[vba][$-C09][/vba] .....just wondering what that part is or does.


Just Currious, Everything Works OK.

[geekgirlau]

http://office.microsoft.com/en-us/ex...5.aspx?redir=0

[velohead]

so it's the locale
(thx for the link, btw)

[Aussiebear]

Hi GG, Just to clarify... "C09"as in Calendar Gregorian (Middle East French) or have I read this incorrectly??

[velohead]

when I recorded the macro (to get the code), I changed the locale
from English (US)
to English (Australian).


this is taken from gg's link, and is 5 items from bottom of web page....

Hexadecimal
valueLanguageLCID
0C09English (Australian)3081

[Aussiebear]

Thanks