ExcelBanter - Excel totals

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Excel totals (https://www.excelbanter.com/excel-worksheet-functions/143562-excel-totals.html)

Was doing Income Statement in QB Financial Statement Designer. Did not work
- spent considerable time on phone with QB but they could not fix. Exported
to Excel. Am using Accounting totals for everything but it is not working
right with a negative number. I need the total to be $ -45,833.26.
Because I'm using accounting format, it wants to do $ (45,833.26). Using
the currency format gives me the $ right next to the total $-45,833.26 - but
the number is right. Any suggestions would be appreciated.

Format as Accounting and then format Custom and change the format to use a minus sign instead of brackets (the 2nd format code,
that is, after the first semicolon, is for negative numbers)
You'll probably end up with a Format code something like this:

_($* #,##0.00_);_($* -#,##0.00);_($* "-"??_);_(@_)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ejdt" wrote in message ...
| Was doing Income Statement in QB Financial Statement Designer. Did not work
| - spent considerable time on phone with QB but they could not fix. Exported
| to Excel. Am using Accounting totals for everything but it is not working
| right with a negative number. I need the total to be $ -45,833.26.
| Because I'm using accounting format, it wants to do $ (45,833.26). Using
| the currency format gives me the $ right next to the total $-45,833.26 - but
| the number is right. Any suggestions would be appreciated.

One way:

Format/Cells/Number/Custom $* #,##0.00;$* -#,##0.00;$* "-"??;@

In article ,
ejdt wrote:

Was doing Income Statement in QB Financial Statement Designer. Did not work
- spent considerable time on phone with QB but they could not fix. Exported
to Excel. Am using Accounting totals for everything but it is not working
right with a negative number. I need the total to be $ -45,833.26.
Because I'm using accounting format, it wants to do $ (45,833.26). Using
the currency format gives me the $ right next to the total $-45,833.26 - but
the number is right. Any suggestions would be appreciated.