how do i get negative numbers in brackets in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i find i cannot enter negative numbers in accounts in brackets
but this is the accounting convention
is it hidden in excel
or do i need a plug in
 
Hi Maverick,

Enter numbers using the minus symbol, but format your cells: Format => Cells
=> Number [tab] and in the Type box, enter "#,##0.00_ ;[Red](#,##0.00) "
(without the quotation marks).

Ewan.
 
Back
Top