Excel formatting - what does [$-F400] mean?

[David Thielen]

In Excel, for the chart Axis number formatting, the first Time value
has a format code of: [$-F400]h:mm:ss AM/PM

What does the [$-F400] mean? THere are a ton of formatting strings
that have [$ ... ] but I can't find it referenced anywhere.

thanks - dave

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[Colbert Zhou [MSFT]]

Hello Dave,

I search and find some Excel format related document, but it either does
not cover the [$F-400] prefix. But its effect seems to be same as h:mm:ss
AM/PM. I am consulting this topic via internal channel and will let you
know when I get replies. Thanks for the patient.


Best regards,
Ji Zhou
Microsoft Managed Newsgroup Support Team

 

[David Thielen]

Hello Dave,

I search and find some Excel format related document, but it either does
not cover the [$F-400] prefix. But its effect seems to be same as h:mm:ss
AM/PM. I am consulting this topic via internal channel and will let you
know when I get replies. Thanks for the patient.

Thank you. Weird that it is not documented anywhere because a lot of
the standard formats have [$-****] with all kinds of codes.

thanks - dave

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[Tony Jollans]

The symbol after the $ is the currency symbol to use and the (hex) number
after the hyphen is a locale identifier. I'm not really an Excel person, so
I'm not sure what effect the locale identifiers have.

 

[David Thielen]

The symbol after the $ is the currency symbol to use and the (hex) number
after the hyphen is a locale identifier. I'm not really an Excel person, so
I'm not sure what effect the locale identifiers have.

Hi;

Thank you. They have it in date formats too - any idea what it means
there?

thanks - dave

david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com

Cubicle Wars - http://www.windwardreports.com/film.htm

 

[Tony Jollans]

It's always a locale identifier, and maybe some other codes as well -
calendar type, for example, - see
http://office.microsoft.com/en-us/excel/HA010346351033.aspx#Locale for some
more details.