Automating preferred Number Formatting

[polarisking]

My preferred number formatting is #,##0

Is there a way to automate this by "replacing" what Excel says is Number (I have to go in and opt in for Use 1000 separator and set the Decimal places to 0)?

I have another which is #,##0;-#,##0;;@

Again, I'd like to do this with one button simplicity. Any ideas? Thanks in advance

 

[GraH - Guido]

using these?

 

[polarisking]

The Comma option puts the number in Accounting format, so it doesn't do what I need it to do. Thank you for the suggestion.

 

[GraH - Guido]

Accounting format is the icon at the far left. For me the comma sets thousand separator, with decimals, like Microsoft explains too. The decrease icons allows to reduce the decimals.
Maybe use the shortcut?

 

[polarisking]

Ctl-Shift-1 is exactly what the doctor order. Thank you GraH-Guido.