Negative Numbers in Parentheses

T

tiggy2

I have Excel 2002 (XP) on my present laptop. I need to be able to display
negative numbers/currency values in parentheses using accounting format but
with an input locale of UK set in Regional Options in Control Panel (where I
live) the option is not available (only the "-" sign). However with an input
locale of USA the negative parentheses options are all available and work
fine. I have set the negative number formats in Regional Options (Windows
XP) to show parentheses in both number and currency formats but these don't
wash through to Excel. I had this problem before on a previous machine and
found a fix but I can't remember what or where - I know I didn't have to set
up a Custom format though! I seem to rember changing a registry value?
Can anyone please help - it's driving me nuts!
 

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

Excel 2007 - display negative numbers with minus sign and parenthe 3
Excel not using regional settings 6
Displaying negative values in parentheses 3
Negative Numbers 8
How do I get the parenthesis option in NUMBERS format, Excel 2007. 2
Separting negative numbers from letters in cells 1
Negative numbers use braces 4
Negative Numbers 10

Top