Shortcut to Format any Number in Excel

Here's some shortcut to easily convert a number to any format.
First, when you add a number in an excel cell, it defaults to a "general" format - "1234". To quickly change it to a "number" format - 1,234.00 here's what you do:

                      1. Click the cell with the number
                      2. Press Ctl-Shift-1
                      3. Done!

Easy!

Other combination and formatting results are as follows:

                     Ctl-Shift-2: Hour - 12:00AM
                     Ctl-Shift-3: Date -  18-May-03
                     Ctl-Shift-4: Dollar - $1,234.00
                     Ctl-Shift-5: Percent -1234%
                     Ctl-Shift-6: Scientific Notation -1.23E+03

Happy Computing!

Tweet