Excel 2007 - display negative numbers with minus sign and parenthe

N

Nadine

Excel 2007 - display negative numbers with minus sign and parentheses

We go into format cells - select number - and there are only black or red
choices with or without a minus sign. Don't have any of the choices with
parentheses,

In excel 2003 have choices with parentheses in format cells - number

Is this feature gone in Excel 2007, search help and the help says - with or
without paretheses, but when following instructions there are no options for
parentheses are showing.

OS is Vista Enterprise
 
L

Luke M

Could you try using a custom format, something like:

0.00_);-(0.00)

Note that the part after semicolon is how you want to format negative
numbers (in front of semicolon is how to format positive numbers)
 
N

Nadine

Answered it myself. Went into Regional and Language Options, Customize this
format.
But first time I had just changed the negative value on the Numbers Tab
But changed didn't show up in Excel
Went back in and on the Currency Tab, changed the negative number format
there as well.
Reopened Excel now have the format options with parathesis.
Guess needs to be set on both Numbers and Currency tabs for it to show in
Excel properly.
 
B

Bernard Liengme

Sounds like you are working with currency. You can change the options using
this procedure
Windows start button|control panel
regional and language options
regional options tab
click the customize button
currency tab
change the negative currency format to show ()'s.

You can always make a custom format. In my set up there is no foramt like
($123.24) with parentheses. Here are some sites I found with Google search
using "Excel 2007 number format"

http://www.microsoft.com/communitie...60-9e6d-b8b236d49048&cat=&lang=&cr=&sloc=&p=1

http://www.msoffice-tutorial-training.com/number-formatting.html

http://books.google.ca/books?id=9f7...mcWyBA&sa=X&oi=book_result&ct=result&resnum=6

best wishes
 

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


Top