Excel - negative values

  Cila 14:15 13 Apr 2007
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 2007

Use a custom format like

0.00;(0.00)

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

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Photoshop CC 2018 released with new Curvature Pen and better brush tools

Camera tips to take better iPhone photos

Les meilleures applications de covoiturage 2017