» Quickly Typing Dates into Cells
CATEGORY - Excel Editing
VERSION - All Microsoft Excel Versions
Type the day (serial number only) into cell A1 and add the following formula to insert the month and year into cell B1:
=DATE (YEAR(TODAY()), MONTH(TODAY()), A1)
Type a full number in the cell and change it to a date by using the following formula:
=DATEVALUE(LEFT(A1,2)&"/"&MID(A1,3,2)&"/"
&RIGHT(A1,2))
For example, type 122203, the result is 12/22/03.
Book Store:
Recommended Books:
- Accounting for Dummies
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- The New Financial Order: Risk in the Twenty-First Century
- Analysis of Financial Statements
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Now, Discover Your Strengths
Formatting Custom Numbers
Bill Getz Posted on: 31-12-1969
I want to know how to show a number, twice its value. For example showing 2 boxes of data into one. So I would have a 14, and I would want to show as a 28.Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
