View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
xlouisedoll xlouisedoll is offline
external usenet poster
 
Posts: 1
Default ( ) instead of -

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!