Excel - negative values

  Cila 14:15 13 Apr 07
Locked

Can anyone tell me how I can display negative values in a spreadsheet to display brackets. It sems to drop the brackets and change to red. I don't mind the red but I would like the brackets to be displayed. I have tried formatting cell to accounting and currency and get same result.

Many thanks
Cilla

  VoG II 14:36 13 Apr 07

Use a custom format like

0.00;(0.00)

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

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

Method Studios' title sequence for BBC series Taboo is truly unsettling

Best Pages for iOS tips | How to use Pages for iPad & iPhone: 6 simple tips to get more out of…