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

iMac Pro review

25 book design and illustration tips

iMac Pro review

Idées cadeaux pour geeks et tech addicts