Number Format Shortcut in Excel

I must be dense. All these years I've had one main gripe about Excel and that's always having to format numbers with a thousands separator and two decimal places, and no easy way to do it.

Now I find out there's been a shortcut for it all along.

Ctrl+Shift+!

I found the shortcut in Excel 2010 Bible, but it's even in Excel 2003 books.

What a moron I've been!

Enjoyed this guide?

Join our newsletter to get the latest Excel tips delivered to your inbox.

You can unsubscribe anytime. See our Privacy Policy.

Archived comments

Comments migrated from the previous version of the site. Adding new comments is disabled.

TyMarch 29, 2013 at 03:40 PM

You are not the only one. THANK YOU SO MUCH!!!!

Gregoryexcelsemipro.comMarch 30, 2013 at 06:16 PM

Thanks!