Excel: Currency Format Shortcut

Last week, someone asked me if there's a keyboard shortcut to change a cell's number format to currency - and I'm pleased to say that yes, there is! And it's pretty easy to remember too:

Ctrl + Shift + $

This will change the number format of whatever cell(s) you have selected to currency format (with the default dollar sign and two decimal places).


Post a Comment