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.

Best phone camera 2016/2017: Galaxy S7 vs iPhone 7 vs Google Pixel vs HTC 10 Evo vs OnePlus 3T vs…

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

The Pantone Colour of the Year 2017 is Green

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…