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

J

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.
 
N

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
[email protected]

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/
 
Top