AboutPricing

Get instant live expert help on I need help with the accounting style shows negative numbers in

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.
< Go Back

    Here are some problems that our users have asked and received explanations on

    I am trying to apply the Accounting number format to the 1st row of sales figures and to the total row. Then apply the comma style to the remaining sales figures. However, BOTH the accounting style and the comma style display as "######."
    Solved by T. S. in 17 mins
    On the Cities worksheet, select the range E14:H18 and apply Comma Style with zero decimal places. Select the range E13:H13 and apply Accounting Number format with zero decimal places.
    Solved by M. E. in 28 mins
    In cells D5, D6, D7, D8, and D9, insert Column sparklines using the values in the Bulbs and Trees columns. Format the sparklines using the styles in the first row as follows: D5: Sparkline Style Accent 1, Darker 50% D6: Sparkline Style Accent 2, Darker 50% D7: Sparkline Style Accent 3, Darker 50% D8: Sparkline Style Accent 4, Darker 50% D9: Sparkline Style Accent 5, Darker 50% To the range B5:C5, apply Comma Style with zero decimal places, and to the range B6:C9, apply Accounting Number Format. Center the Summary worksheet Horizontally and change the Orientation to Landscape. Insert a custom footer in the left section with the file name.
    Solved by O. F. in 16 mins
    9. Configure the pivottable to show total appraised value for art items by location and category. Format all money values with Accounting style. Change the row and column headings to indicate what they reference in the pivottable.
    Solved by Z. Y. in 25 mins
    Apply Accounting Number Format to the range C5:C16. Apply Accounting Number Format to the first row of monetary data and to the total row. Apply the Comma style to the monetary values for the other employees. Underline the last employees monetary values and use the Format Cells dialog box to apply Top and Double Bottom border for the totals.
    Solved by X. E. in 30 mins