Excel totals

[ejdt]

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.

 

[Niek Otten]

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



| 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.

 

[JE McGimpsey]

One way:

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