How to get Excel format left-aligned for numbers?

Question

I love to format thousands by using comma by hitting the comma button on the ribbon.

And that will right aligning my numbers.

How can I left align those?

Solution

Instead of clicking the comma button on the ribbon, format your number(s) by pressing Ctrl+Shift+1 and then you can left align them.

Explanation

• This hotkey will set the number format of your selected cell to Number
• The comma button will set that to Accounting

Comments

[Nam G VU]

What formation text should I enter to have the number values displayed as the comma button?

[Mike Fitzpatrick]

Pressing Ctrl+Shift+1 should automatically format your number with commas separators and two digits after the decimal point. You shouldn't need to specify the number format. However, it may be dependent on your locale settings.

[Nam G VU]

Thanks. I have asked it here superuser.com/q/883248/34893