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
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.
"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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks