View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Custom Cell Formats

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