The ASAP Utilities menu in Excel (English)
Convert/recognize dates...
English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語Text › 9. 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
Starting this tool
- Click ASAP Utilities › Text › 9. Convert/recognize dates...
- Specify a Keyboard Shortcut: ASAP Utilities › Favorites & Shortcut keys › Edit your favorite tools and shortcut keys...
Additional keywords for this tool:
us date change to europe date
us date change to europe date
©1999-2024 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands
Empowering Excel Users Worldwide for 25 Years
Empowering Excel Users Worldwide for 25 Years