» 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:
- Business Analysis with Microsoft Excel (2nd Edition)
- Absolute Beginner's Guide to Microsoft Excel 2002
- Advanced modelling in finance using Excel and VBA
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!
- Guide to Financial Reporting and Analysis
- Absolute Beginner's Guide to Microsoft Office Excel 2003
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
