PDA

View Full Version : MS Excel ? (red) versus minus in red



23-05-2002, 03:44 PM
I have reloaded all my software after finally doing a 'normal' reformat of the hard drive but now MS Excel does not let me format (a cell) so that negative mumbers are shown in brackets (and in red) - only the minus sign is offered

How can I 'fix' this ?

I used to have this available in the normal format , number choices but cannot see it anywhere .... please help

23-05-2002, 04:36 PM
Try format - cells - number - custom

Choices should be there, if not here is one option that you could paste in there.

#,##0_);[Red](#,##0)

Cheers

TW

23-05-2002, 06:02 PM
Wonderbar
Great - thanks a million

PS: I couldn't copy and paste it but was able to create a new 'Custom' format by highlighting and existing Custom format and amending it to your recomendation in the 'Type:' field ...
and now it's there for future use