» 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:
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Special Edition Using Microsoft Excel 2002
- The One Page Business Plan: Start With a Vision, Build a Company!
- The New Financial Order: Risk in the Twenty-First Century
- Microsoft Excel Version 2002 Step by Step
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
