|
» Displaying the serial number behind Date format in Microsoft Excel
CATEGORY: Excel Dates , Excel Keyboard Shortcuts |
VERSIONS: All Microsoft Excel Versions |
|
Select a cell and enter today date into the cell by pressing Ctrl+; than press Ctrl+~. |
| Screenshot // Displaying the serial number behind Date format in Microsoft Excel |
  |
|
RATING:
3.38
VIEWS: 51829 |
||||
Best than the Best
Deepak Tapse wrote on December 31, 1969 19:00 EST
The site regarding Excel is very useful to all, specially who is in Account Department.
Dated entries
Keith Armstrong wrote on December 31, 1969 19:00 EST
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 wrote on December 31, 1969 19:00 EST
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
Sponsors:
 |
Book Store:
Recommended Books:
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
