Format excel cells

[Bruce4243]

When I try to format cells to select negative numbers, I can only see -numbers and not the (numbers) for selection. How can I change this?

[#2]

Hi @Bruce4243 

Select the range you like to format then press CTRL+ 1 > Number > Number and select negative number as you like to display

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer and like to help the other members find it more