» Displaying the serial number behind Date format in Microsoft Excel
CATEGORY - Excel Dates , Excel Keyboard Shortcuts
VERSION - All Microsoft Excel Versions
Select a cell and enter today date into the cell by pressing Ctrl+; than press Ctrl+~.
Press Ctrl+~ again to restore the sheet to its normal appearance.

Book Store:
Recommended Books:
- Harry Potter and the Order of the Phoenix (Book 5)
- Analyzing Markets, Products, and Marketing Plans
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- The Interpretation of Financial Statements
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
Best than the Best
Deepak Tapse
The site regarding Excel is very useful to all, specially who is in Account Department.
Dated entries
Keith Armstrong
I Imported a list of transactions from PayPal website.
The dates are set as 22 Nov. 2006 and this will not sort in excel.
When i remove the (dot) with replace command the first date in the list converts but the rest do not.
Any suggestions?
date as number
Chirag
I faced a different problem. all the dates in a column appear as number only. when we click on the cell, we can see the date behind that number in formula bar but i am unable to restore the dates!
HEEEEEEEEEEEEEEELp

