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.

Surface Pro 5 News - release date, UK price, features, specs

Gear VR vs. Daydream: Which delivers the best VR experience?

Best Mac antivirus 2017