LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
divide a total, subtract one then format as a percentage [email protected] Excel Worksheet Functions 4 November 27th 06 08:14 PM
Pivot Table Conditonal Format of the Grand Total michelle Excel Worksheet Functions 3 November 2nd 06 11:39 PM
excel table auto format total row should see sum formula already Chris Lampard Excel Worksheet Functions 0 May 26th 06 01:21 PM
Convert [h]:mm sum total format to number format Guy Excel Worksheet Functions 1 August 5th 05 05:56 AM
Adding Data Using Multiple Worksheets to Total into a Grand Total Lillie Excel Worksheet Functions 1 April 19th 05 08:34 PM


All times are GMT +1. The time now is 02:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"