Number Format Shortcut in Excel

by Gregory on September 9, 2010

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...
Ty March 29, 2013 at 8:40 am

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

Gregory March 30, 2013 at 11:16 am

Thanks!

Comments on this entry are closed.

Previous post:

Next post: