ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Custome Format (https://www.excelbanter.com/excel-discussion-misc-queries/243255-custome-format.html)

Hal

Custome Format
 
Can anyone tell me what the [$-409] does in the custom cell format of
[$-409]dddd, mmmm dd, yyyy

thanks

Hal

Jacob Skaria

Custome Format
 
That is the locales/language ID assigned by Microsoft..

Refer below for the complete list
http://msdn.microsoft.com/en-us/goglobal/bb964664.aspx

If this post helps click Yes
---------------
Jacob Skaria


"Hal" wrote:

Can anyone tell me what the [$-409] does in the custom cell format of
[$-409]dddd, mmmm dd, yyyy

thanks

Hal


Bob Phillips[_3_]

Custome Format
 
It is an international code, 409 is the States, so it is saying use the US
$.

--
__________________________________
HTH

Bob

"Hal" wrote in message
...
Can anyone tell me what the [$-409] does in the custom cell format of
[$-409]dddd, mmmm dd, yyyy

thanks

Hal





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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com