using brackets in excel

  marcus22798 20:44 22 Apr 03
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 03

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 03

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

  Tog 21:17 22 Apr 03

that's what happens when your connection drops out

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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac