» Changing the Number Formatting in Excel 2007
CATEGORY - Excel Format
VERSION - Microsoft Excel 2007
Using the mouse
Select Home -> open Number Format dropdown box (in Number Group).
Using keyboard shortcuts
To open the Number dropdown box press Alt+H+N+Down Arrow, and press the Down Arrow again.
To change the number format:
From date to number press Ctrl+Shift+~
From number to date & time press Ctrl+Shift+@
From number to date press Ctrl+Shift+#
Book Store:
Recommended Books:
- Retire Young, Retire Rich
- Business Plans Kit for Dummies (With CD-ROM)
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Writing Excel Macros with VBA, 2nd Edition
- Not-for-Profit Accounting Made Easy
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
No comments have been submitted.

