لطفا منتظر باشید ...
• Table of Contents• Reviews• Reader Reviews• Errata• AcademicExcel HacksBy
David Hawley, Raina HawleyPublisher: O''ReillyPub Date: March 2004ISBN: 0-596-00625-XPages: 304The tips and tools in Excel Hacks
include little known "backdoor" adjustments for everything
from reducing workbook and worksheet frustration to hacking
built-in features such as pivot tables, charts, formulas and
functions, and even the macro language. This resourceful,
roll-up-your-sleeves guide shows you new ways to make Excel
do things--from data analysis to worksheet management to
import/export--that you never thought possible.
Excel Hacks increases productivity with
Excel and gives you hours of "hacking" enjoyment along the
way.
Hack 65 Convert Dates to Excel Formatted Dates
Dates imported from other programs frequentlycause problems in Excel. Many people manually retype them, but there
are easier ways to solve the problem.
Let's
look at some of the date formats you might encounter and how to
convert them to standard Excel dates.As Figure 6-6 shows, the formulas in column B
convert the data in column A to three results in column C, all of
which follow the U.S. date format of mm/dd/yy.
Figure 6-6. Date formats converted to valid dates (U.S. format)
Figure 6-7 shows the same approach at work, except
that the cells in column C were formatted with the European date
format of dd/mm/yy.
Figure 6-7. Date formats converted to valid dates (European format)
Hopefully, these nifty formulas will take some of the stress out of
working with imported dates.
