|  

» Changing the Number Formatting in Excel 2007

CATEGORY - Excel Format VERSION - Microsoft 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+#




Rate This Tip
12 34 5
Rating: 3.25     Views: 5092
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments