» Displaying the Serial Number Behind the Date
CATEGORY - Excel Keyboard Shortcuts
VERSION - All Microsoft Excel Versions
To see the serial number behind a date:
Press Ctrl+` (the ` key is to the left of the 1 key) to change the display of the cell's contents.
To convert a date to its serial number:
Press Ctrl+Shift+~ to change the cell's contents.

Book Store:
Recommended Books:
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Business Plans For Dummies®
- Special Edition Using Microsoft Word 2002
- Keys to Reading an Annual Report (Barron's Business Keys)
- The Financial Numbers Game: Detecting Creative Accounting Practices
No comments have been submitted.

