» 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 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Microsoft Excel Version 2002 Step by Step
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- How to Pay Zero Taxes (Annual)
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
Is this a bug
james Posted on: 31-12-1969
I have had so much trouble with this at work, is it a bug in excell any machine that i try and put in "9-11" it will revert to a date when i do not want it to be a date it is meant to be "9 TO 11" i am stumped can you please help.Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
Then choose text
This should stop "9-11" from becoming a date and leave it as "9-11"