Microsoft Excel has many formats for entering content inside a cell. By default when you open a workbook, all cells are available in “General” format. Excel will accept text content inside cells without any errors. However, when you enter number inside a “General” formatted cell, you will see a validation error. Here are simple shortcuts to change cell format in Excel quickly.
Related: How to insert sigma or summation symbol in Excel?
Cell Validation Error
In the Excel worksheet, you need to look for tools in the ribbon and then format the menu according to the data you want to enter in the cells. Below is the screenshot of Excel in Office 365 version on Mac. You can change the format under “Home” tab by clicking on the format dropdown box.
You have to change the desired format before typing the content. Otherwise, Excel will show you error with a green mark on the top left corner within the cell. You can hover over the cell and click on the warning symbol to see more details. For example, when you type number inside a general cell and press enter, you will see “Number Stored As Text” warning.
Therefore, it is necessary to change the cell format before you enter the content inside a cell.
Shortcuts to Quickly Change Cell Format
However, navigating through menu and changing the cell format is time consuming task. In order not to waste time, Excel provides some shortcut keys for changing cell format. You can find them below:
Shortcut | Cell Format |
---|---|
Ctrl + Shift + ~ | General format |
Ctrl + Shift + ! | Number format with two decimals and thousand separator |
Ctrl + Shift + @ | Time format, you can set AM / PM |
Ctrl + Shift + # | Date format, change the cell value to default date format |
Ctrl + Shift + $ | Currency format, adds the default currency symbol to number with two decimal. Negative value will show with red color and inside brackets. |
Ctrl + Shift + % | Percentage format |
Ctrl + Shift + ^ | Scientific format |
Good part is these keyboard shortcuts for changing cell format will work both on Windows and Mac Excel version.
Example
Below is an example, how the cell value 123 will change when you apply these shortcuts to change the format:
Value | Shortcut | Result | Format |
---|---|---|---|
123 | Control + Shift + ~ | 123 | General |
123 | Control + Shift + ! | 123.00 | Number |
123 | Control + Shift + @ | 12:00 AM | Time |
123 | Control + Shift + # | 2-May-00 | Date |
123 | Control + Shift + $ | ¥123.00 | Currency |
123 | Control + Shift + % | 12300% | Percentage |
123 | Control + Shift + ^ | 1.23E+02 | Scientific |
Leave a Reply
Your email is safe with us.