Excel handles dates and times numerically. The numbers for dates range from 1 to 2958465, with 1 indicating January 1, 1900, and 2958465 indicating December 31, 9999.
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.
Screenshot // Displaying the Serial Number Behind the Date
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
I'm trying to create a spreadsheet with a column with a start date and would like to have another column that will tell me how many days that project has been open. That part was easy, but because I formatted several rows for future use I now have the serial number showing in all the columns that do not have a date entry. How do I get rid of the serial number?
I want pure number without time and date format.
example: in cell type the 7:49
I want number 7 in cell and 49 in other cell
only I need to numbers without format date and time.
please help me
Is it possible to enter dates prior to 1900? I'm trying to chart a long time series.
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?
Ctrl (number 5 key) will make the cell italics?!? not change the date format?!?
How do u type the # key without the shift key. Just curios
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.