Formatting negative currency - doesn't have brackets

External Since: Aug 09, 2007 Posts: 2

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.

--
Regards
Bob

External Since: Jul 08, 2005 Posts: 15610

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.

RobWN wrote:
>
> 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.
>
> --
> Regards
> Bob

--

Dave Peterson