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

“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.

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
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
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
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
Solved by C. S. in 14 mins