ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Excel total format (https://www.excelbanter.com/excel-worksheet-functions/143560-excel-total-format.html)

ejdt

Excel total format
 
Transferred Income Statement from QB Financial Statement Designer to Excel
because it would not come out correctly in QB (spent considerable time on
phone with QB to fix but could not). One total is fine - is formatted as
accountant. The other total will not format right. I want it to be
accountant style with -45,833.26. Accountant's style wants to do
(45,833.26). Accountant's style puts the $ where I want it to be which is on
the left side. Currency style puts it $(45,833.26). Any suggestions? I've
tried everything I can think of.



JE McGimpsey

Excel total format
 
See one way at your other thread.

In article ,
ejdt wrote:

Transferred Income Statement from QB Financial Statement Designer to Excel
because it would not come out correctly in QB (spent considerable time on
phone with QB to fix but could not). One total is fine - is formatted as
accountant. The other total will not format right. I want it to be
accountant style with -45,833.26. Accountant's style wants to do
(45,833.26). Accountant's style puts the $ where I want it to be which is on
the left side. Currency style puts it $(45,833.26). Any suggestions? I've
tried everything I can think of.



All times are GMT +1. The time now is 05:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com