Custom Cell Formats

[Tyro]

I have seen formats like [$-409]h:mm AM/PM appear in the custom formats. The
formatted result is the same with or without the [$-409]. Does anyone know
what the significance of [$-409] is? I have seen this since Excel 95 and
have never seen a reference to this.

Tyro

 

[Mike H]

Hi,

Creating international number formats
http://office.microsoft.com/en-us/excel/HA010346351033.aspx

Mike

 

[Tyro]

Thanks!

Tyro

Hi,

Creating international number formats
http://office.microsoft.com/en-us/excel/HA010346351033.aspx

Mike

I have seen formats like [$-409]h:mm AM/PM appear in the custom formats.
The
formatted result is the same with or without the [$-409]. Does anyone
know
what the significance of [$-409] is? I have seen this since Excel 95 and
have never seen a reference to this.

Tyro