Do not want parenthesis around negative numbers

I

IanMac

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi

Suddenly, all my negative numbers on several different workbooks now show negative numbers with parenthesis.

I prefer a minus sign to show which is what I have had up to yesterday.

I haven't updated or done anything different but I now can't get rid of the parenthesis.

Any advice would be welcome.

Yours, Ian
 
B

Bob Greenblatt

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi

Suddenly, all my negative numbers on several different workbooks now show
negative numbers with parenthesis.

I prefer a minus sign to show which is what I have had up to yesterday.

I haven't updated or done anything different but I now can't get rid of the
parenthesis.

Any advice would be welcome.

Yours, Ian
Click to expand...
You need to change the number format of those cells.
 

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

Currency symbol position 1
have negative numbers appear in parenthesis 5
Excel formula; all negative values return with 0 2
Change colour for negative colums in chart 3
Finding the correct formula 1
excel doesn't registering/saving euro sign before number and negative numbers with red 0
Moving Category Labels on Graphs with negative values 0
want parentheses, not negative numbers 2

Top