Ask a new question

Comma Style button in Excel 2016

Prior to using Excel 2016, (Windows 7) the comma style button inserted a comma in the cell for number format.  Now when I click the comma style button the format changes to accounting and puts the $ in the cell.  It is operating like the Accounting Number Format button.  How can I get the comma style back to the comma style?

Not sure why you are getting the currency symbol; that is not the original setting.

Here are the steps for modifying a style; I made mine give Number but you could change it to accounting with no currency symbol

best wishes

Open the Cell Styles dialog

Right click on the Comma button, select Modify

Apply what ever format you wish

http://people.stfx.ca/bliengme
A Guide to MS Excel 2013 for Scientists and Engineers

25 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

This works as long as I have the sheet open but when I close down Excel and open again, the format is reset.

I tried modify and the APPLY, SAVE.  Still the format resets.  Is there something else that needs to happen to make it a permanent change?

18 people found this reply helpful

·

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 6, 2024 Views 10,040 Applies to: