Negative number formating

L

Lorenzo

I am using Office XP (Excel)and I cannot find
the "brackets" formatting for a negative number.
Can someone help me on how I can do this in XP Excel. I
could easily do it in Office 98 Excel, under the Format
Cell / number function. It seemed to have disappeared in
this new version.
 
J

J.E. McGimpsey

You can still use Format/Cell/Number but choose Custom and enter

0_);(0);0_);@


the _ character reserves enough space for the character that follows
it, so that positive and negative numbers line up.


XL cell formats have four fields. By default, they are for positive
numbers, negative numbers, zero, and text, respectively, though that
can be modified.
 

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

Top