» 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 McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Not-for-Profit Accounting Made Easy
- Definitive Guide to Excel VBA
- A Mathematician Plays the Stock Market
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
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
