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

Hi,

Creating international number formats
http://office.microsoft.com/en-us/ex...346351033.aspx

Mike

"Tyro" wrote:

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

Thanks!

Tyro

"Mike H" wrote in message
...
Hi,

Creating international number formats
http://office.microsoft.com/en-us/ex...346351033.aspx

Mike

"Tyro" wrote:

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