select the cell | go to format | cells | number tab | category :
number | decimal places :0 | choose negative format (1234) | ok |



On Oct 24, 8:13*pm, xlouisedoll
wrote:
Right this is probably going to sound really silly..but I'm not very good
with Excel. Basically..I'm an accounting student and for one of my classes
I've got to produce a balance sheet etc etc. but I'm having problems with the
formatting of my cells for negative numbers. Basically rather than them
showing up as a - (say -2) I want brackets around the number (2), but
whenever I try and do this..it just converts to -2...any ideas on how I get
it to stay as (2) without changing the format of the cells to just text? i.e.
so it still means negative 2?

Any help would be greatly appreciated!