Formatting negative currency - doesn't have brackets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

RobWN - 10 Aug 2007 04:34 GMT

xl03Pro
What dictates the available options in "format cells->currency"
At work (same version of xl) it has negative values as red with brackets whereas my home version
offers only red with a negative sign.

Signature

Regards
Bob

Reply to this Message

Dave Peterson - 10 Aug 2007 05:10 GMT

Excel picks this up from a windows setting:

Windows start button|control panel
regional and language options
regional options tab
click the customize button
currency tab
change the negative currency format to show ()'s.

> xl03Pro
> What dictates the available options in "format cells->currency"
[quoted text clipped - 4 lines]
> Regards
> Bob

Signature

Dave Peterson

Reply to this Message

RobWN - 10 Aug 2007 05:36 GMT

Thanks Dave.
All is well in my world.
I remembered the regional settings but only changed the number format (missed the currency
customization).
I always have trouble with things you do once in a blue moon-probably why I have a love/hate
relationship with this new machine!

Again, thanks.

Signature

Regards
Bob

Reply to this Message