Tip Printed from ExcelTip.com

---

Changing the Number Formatting in Excel 2007


To change the number formatting:

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+#