Built-in Number Format "#,##0_);(#,##0)"

[James Smith]

I want to display my negative numbers in parentheses and should be able to
use one of the built-in number formats.

I select (Format > Cells)(Number tab) and in the category listbox, select
"Number".
The last two items in the Negative numbers listbox do not have parentheses.

The built-in number format that should contain parentheses,
"#,##0_);(#,##0)" has actually changed to "#,##0_);(#,##0)"

Has anyone seen this before ?


I could create a custom number format but this should be built-in.

 

[Norman Harker]

Hi James!

You'll get the last two number options to include () if you change the
Regional options:

Start > Settings > Control Panel Regional Options
Change negative number format (same for currency if required)
Apply
OK

(Instructions vary slightly for Windows XP)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/