Excel - negatives in brackets?

  Neilly 00:46 27 Aug 2003
Locked

If I type in a negative figure, how can I set it to automatically appear in brackets?

Thank you

  Mango Grummit 00:52 27 Aug 2003

It can't be done I'm afraid. "-" is all you can achieve. By the way it is the same for all. The only time you will see brackets is on a prepared accountancy report.

  Peverelli 00:56 27 Aug 2003

I think the advice on this thread did what you're asking. click here

  Mango Grummit 01:02 27 Aug 2003

I stand corrected.

Neilly, a thousand apologies.

  Peverelli 01:05 27 Aug 2003

Sorry Mango, didn't notice your reply :O(

I didn't think it could be done either and then I saw that thread. Then again, that's the beauty of this Helproom.

  Peverelli 01:17 28 Aug 2003

Did it work?

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iPhone X review

Political cartoons in 2017: Chris Riddell, Rebecca Hendin and Dave Brown on what it’s like to…

The best iPhone for 2017

Tennis : comment regarder la finale de la Coupe Davis 2017 ?