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
|