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.

Numbers-Raw

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

Ctrl+Shift+!

Numbers-Formatted

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

What a moron I’ve been!

Related Posts Plugin for WordPress, Blogger...

2 thoughts on “Number Format Shortcut in Excel

Comments are closed.