Formatting a Cell Negative

[Cricketer]

I require a cell to automatically display a negative number to 2 decimal places for accounting (I don't want to type the negative sign every time) To be displayed as -0.00 In formatting I have used Custom and created a new option -General. This works perfectly in showing the number as negative when entered without the negative sign but it does not show the number to 2 decimal place unless it has 2. So 32.65 displays correctly as -32.65 but 84.2 displays as -84.2 and not -84.20, 96 displays as -96 and not -96.00

Any help and guidance very much appreciated (preferably not VBA)

 

[shinigamilight]

Paste this in formatting

-#.00

 

[Cricketer]

-#.00

Many thanks, your help greatly appreciated