I'm doing an accounting and finance course in which the lecturer requires us to format numbers by putting negative numbers in parentheses - I'm told this is a firaly standard acconuting practice. I've found number formats which put negative numbers in red, but not in parentheses. I tried writing my own format, by putting in "#####;(#####)" but this rounded the numbers off to integers. I tried putting in the decimal point, but this resulted in every number having a decimal point. I just want it to treat numbers as general, ie putting in decimals if I've got them, and leaving them out if I don't, and put negative numbers in parentheses. Can anyone tell me how to do this?
cheers,
-Iainm
cheers,
-Iainm