Displaying negative numbers - inconsistent between desktop and lap

G

Guest

On my desktop PC, in order to have the option of getting negative numbers in
Excel displayed in brackets I need to adjust the Negative Numbers setting in
the Regional Settings part of the Control Panel….this works fine. However,
an identical approach to the same problem on my laptop does not allow the
option of bracketing negative numbers. The Regional Settings are correctly
set, but I’m only offered red negatives, or numbers with a minus symbol.
Is there another setting that I should check?
 
P

penri0_0

Hi,

Try formatting the cells in Excel itself, select the Number tab, Custom
and then select #,##0;(#,##0)

hope that works for you
 

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

Negative numbers use braces 4
Negative Numbers 10
Negative Numbers Display 1
Option to put brackets around negative numbers not available in 20 3
Negative numbers in brackets 4
Negative Numbers in Brackets - HELP! 21
Default Negative Number format across versions 5
Negative numbers 5

Top