» 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:
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
