Excel - negatives in brackets?

  Neilly 00:46 27 Aug 03
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 03

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 03

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

  Mango Grummit 01:02 27 Aug 03

I stand corrected.

Neilly, a thousand apologies.

  Peverelli 01:05 27 Aug 03

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 03

Did it work?

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

Xiaomi Mi5s review: The Xiaomi flagship that could replace your Samsung, LG, HTC or Apple phone

1995-2015: How technology has changed the world in 20 years

Mental Canvas is a brand new drawing app that's quite unlike any other

New MacBook Pro 2016 review | MacBook Pro with Touch Bar review: Apple's super-expensive new…