Format Data
Press | To |
|---|---|
Alt+' (apostrophe) | Display the Style dialog box. |
Ctrl+1 | Display the Cells dialog box. (Note that you must use the 1 key above the keyboard, not on the keypad.) |
Ctrl+Shift+˜ (tilde) | Apply the General number format. |
Ctrl+Shift+$ | Apply the Currency format with two decimal places (negative numbers in parentheses). |
Ctrl+Shift+% | Apply the Percentage format with no decimal places. |
Ctrl+Shift+⁁ (caret) | Apply the Exponential number format with two decimal places. |
Ctrl+Shift+# (pound) | Apply the Date format with the day, month, and year. |
Ctrl+Shift+@ | Apply the Time format with the hour and minute and AM or PM. |
Ctrl+Shift+! | Apply the Number format with two decimal places, (exclamation point) thousands separator, and minus sign (–) for negative values. |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access