Get instant live expert help on I need help with comma style number format excel

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

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.

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.

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.

in cell G2 in the valuable worksheet, enter the YEARFRAC function to calculate the number of years from the release date and the date in cell Q2. Use relative and mixed references correctly. format the value with comma style with one decimal place. copy the function to the range G3:G40