| Dates imported from other programs frequently cause 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. |