using brackets in excel

  marcus22798 20:44 22 Apr 2003
Locked

Are there any excel buffs out there who would know how to use brackets eg (12) to symbolise a minus figure when doing your accounts rather than using eg -12. Excel doesn't seem to recognise brackets???

cheers marcus

  Alan2 21:08 22 Apr 2003

Go to format/custom and put the following in by amending one of the default settings:-

£#,##0;£(#,##0)

I removed the RED and the minus sign.

It works on mine.

Alan.

  Tog 21:16 22 Apr 2003

#,##0;[<0](#,##0);General

  Tog 21:17 22 Apr 2003

that's what happens when your connection drops out

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

Elsewhere on IDG sites

iMac Pro review

Illustrator Charles Williams on how to create magazines and book covers

iMac Pro review

Les meilleures prises CPL (2018)