I seem unable to display negative values with brackets

G

Guest

Under - format - cells - number - negative numbers I do not have the option
to choose 'brackets'
 
R

Roger Govier

Hi

Maybe you need to go to Control Panel>Regional
Settings>Customise>Negative number format.
On my machine I get the option for brackets even when this is set
to -1.1, but maybe for you, you need to set negative format to (1.1)
 
G

Gord Dibben

Hi also.

When in Regional Settings, change the setting under "Currency" tab rather than
the "Number" tab.


Gord Dibben MS Excel MVP
 
R

Roger Govier

Hi Gord

I think you had pointed this out to me once before. Sorry, the brain is
getting"addled" today, and I totally forgot.
Thanks for the memory jog.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Displaying negatives with (brackets) 3
Excel not using regional settings 6
Option to put brackets around negative numbers not available in 20 3
Negative Number Display -- need Brackets 7
Negative Numbers in Brackets 2
Spreadsheets: negative numbers in brackets 2
Brackets on negative percents. 3
Lining up decimal points with negatives in brackets 2

Top