logo ASAP Utilities

You can do this too

Download "The one essential add-in for all Excel users."
Sit down and relax, while ASAP Utilities does the rest!

“Working in Excel will be fun again with all these extra supersmart tools”

ASAP Utilities, description of our Excel tools

English (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語

Text » Convert/recognize dates...

This utility helps you to convert the not recognized dates in the selected cells.
Sometimes Excel treats dates as text. This problem often occurs when data is imported or copied from other programs. The problem is often caused by a difference between the date formats in your data and the local settings on your computer.
When Excel doesn't recognize these dates, they are left aligned, the cell formatting to display the dates doesn't work and you can't use them in your calculations.

With this utility you can quickly convert them so that Excel recognizes them as proper dates.
The text-date values all have to be constructed in a similar logical way in order for this utility to convert them.

Your last used settings will be remembered.

Screenshots

Text » Convert/recognize dates...

Starting this utility

In the Excel menu choose: ASAP Utilities » Text » Convert/recognize dates...

« Return to the list of “Text” tools.
« Previous
Spell/write out numbers or amounts (EN, DE, NL)...
 
 Next »
Delete leading and trailing spaces
Excel 2010 with ASAP Utilities in the menu
Download ASAP Utilities
Additional keywords for this tool:
us date change to europe date

Follow ASAP Utilities on Facebook



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook