Negative numbers in parentheses

[Ray Masuda]

Excel 2007: I'm trying to print negative numbers in parentheses in my worksheet. When I go to the numbers dialogue box and click "numbers" or "currency", the only options that are shown are to print negative numbers with a minus sign, or print in red. When I format my cell to "numbers", "currency" or "accounting" and enter a negative number, it appears with a minus sign in front of the number.

I also have Excel 2007 on my laptop and am not experiencing any problems. Negative numbers appear in parentheses in the number, currency and accounting formats.

Have I inadvertently adjusted a setting somewhere? Thanks for any help anyone can provide.

Ray

 

[barry houdini]

Hello Ray,

Sorry can't help you getting those formats automatically but you could use a custom format, e.g. select "custom" and type this in the box.....

0.00;(0.00);0

 

[Ray Masuda]

Thanks Barry. Your suggestion works, but there is something fundamentally missing in my program. I've lost the automatic option to print parentheses.

I think I've used the wrong forum to post this question. I'll repost to another forum. Sorry about that.