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.