PDA

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



velohead
09-01-2010, 04:10 PM
Hi All,

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

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


Just Currious, Everything Works OK.

geekgirlau
09-01-2010, 05:26 PM
http://office.microsoft.com/en-us/excel-help/creating-international-number-formats-HA001034635.aspx?redir=0

velohead
09-01-2010, 06:52 PM
so it's the locale
(thx for the link, btw)

Aussiebear
09-01-2010, 11:00 PM
Hi GG, Just to clarify... "C09"as in Calendar Gregorian (Middle East French) or have I read this incorrectly??

velohead
09-02-2010, 04:02 PM
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
09-03-2010, 12:02 AM
Thanks