how do i get negative numbers in brackets in Excel

[maverick accountant]

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

 

[ewan7279]

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.