» 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:
- Seven Habits Of Highly Effective People
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The Analysis and Use of Financial Statements
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- Microsoft Word Version 2002 Inside Out
Mr
Charles Royall Posted on: 31-12-1969
In my version of Excel 2000, to turn a number into a date you merely press Ctrl + # (no shift key). This produces the date in the following format: 25-Apr-03. The same key combination will also change any other pre-existing date format to this format.Just Curios
Ice Cube Posted on: 31-12-1969
How do u type the # key without the shift key. Just curiosCTRL #
Sting Ray Posted on: 31-12-1969
Ctrl (number 5 key) will make the cell italics?!? not change the date format?!?when would you use this
melissa Posted on: 31-12-1969
this is cool to know, but when would you ever use this? wouldn't you have to memorize the number combination for every date in order to use this? dates prior to 1900
Nicky Posted on: 31-12-1969
Is it possible to enter dates prior to 1900? I'm trying to chart a long time series.Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
