MS Excel ? (red) versus minus in red

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

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

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