Keys for formatting data

CTRL+SHIFT+^ - Apply the Exponential number format with two decimal places CTRL+SHIFT+# - Apply the Date format with the day, month, and year

CTRL+SHIFT+@ - Apply the Time format with the hour and minute, and indicate A.M. or P.M.

CTRL+SHIFT+! - Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values

CTRL+SHIFT+& - Apply the outline border
ALT+' (apostrophe) - Display the Style dialog box

CTRL+1 - Display the Format Cells dialog box

CTRL+SHIFT+~ - Apply the General number format

CTRL+SHIFT+$ - Apply the Currency format with two decimal places (negative numbers appear in parentheses)

CTRL+SHIFT+% - Apply the Percentage format with no decimal places