Negative Numbers and Brackets
Negative Numbers and Brackets
(OP)
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
Thanks





RE: Negative Numbers and Brackets
TTFN
RE: Negative Numbers and Brackets
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
RE: Negative Numbers and Brackets