O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required