how do i get negative numbers in brackets in Excel
 

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

how do i get negative numbers in brackets in Excel
 

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.

"maverick accountant" wrote:

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