Negative Numbers and Brackets

[fb599]

Can anyone tell me how to format a number to have brackets automatically in an Excel spreadsheet when the numbers are negative values please. This is a financial application however !

Thanks

 

[IRstuff]

You should be able to specify that in the custom number formats, just like the ones that make negative numbers red.

TTFN

 

[jproj]

Using custom format, #,###.00;(#,###.00) produces the following:

500.2945 ----> 500.29
-52300.153 ----> (52,300.15)

You can manipulate the format by changing the number of #'s and 0's. The important part is #;(#).

Good luck!

jproj

 

[JEB66]

Format cell, then click on number and then on how you want then negitive numbers to show up( in the lower left of the format pop up)