Date Format Converter for Excel
Date Format Converter is a handy and useful addin for Microsoft® Excel® 2010 or 2007, which helps you convert the text format cells to date&time format cells.
With the Excel Date Format Converter, common short date string or long date string which is applied in America, Britain, France, Russia, Germany, Japan and China can be converted to local date and time.
It supports not only converting local long date string in most language, but also converting international standard time to local time.

For example, if you are working in America, but receive an Excel file from Russia, and the dates in the file are in text format, what can you do? Or if a French man needs to collect data from a Germany website, but the dates he collect are in Germany date form, what should he do? Excel Date Format Converter can play an important role in this case. It will identify the dates in text format and convert them to the local date format.
Now let us enjoy the functionality of excel date conversion and excel time conversion, and improve our work efficiency with Excel Date Format Converter.
|
The date formats it supports are:
short date string as follow:
| 2003.1.2 11:12:13.14PM | 2003-1-2T11:12:13.14PM | 20030102 11:12:13.14PM |
| 2003.1.2 11:12:13PM | 2003-1-2T11:12:13PM | 20030102 11:12:13PM |
| 2003.1.2 11:12PM | 2003-1-2T11:12PM | 20030102 11:12PM |
| 2003.1.2 11 | 2003-1-2T11 | 20030102 11 |
| 2003.1.2 | 2003-1t11:12:13.14 | 200301 11:12:13.14 |
| 2003.01.02 | 2003-1t11:12:13 | 200301 11:12:13 |
| 2003.1 11:12:13.14 | 2003-1t11:12 | 200301 11:12 |
| 2003.1 11:12:13 | 2003-1-2T11:12PM | 20030102 11:12PM |
| 2003.1 11:12 | 2003-1T11 | 200301 11 |
| 2003.1.2 11:12PM | 2003-2T11:: | 200302 11:: |
| 2003.1 11 | 2003-2T11::13 | 200302 11::13 |
| 2003.2 11:: | 2003-1T:::. | 200301 ::. |
| 2003.2 11::13 | 2003-1T:: | 200301 :: |
| 2003.1 :::. | 2003-1T: | 200301 : |
| 2003.1 :: | 2003-1T:12:13 | 200301 :12:13 |
| 2003.1 : | 2003-1-2T:12:13.14 | 20030102 :12:13:14 |
| 2003.1.2 11::13.14 | 2003-1-2T11::13.14 | 20030102 11::13.14 |
| 2003.1.2 11:12:.14PM | 2003-1-2T11:12:.14PM | 20030102 11:12:.14PM |
| 2003.1.2 11PM | 2003-1-2T11PM | 20030102 11PM |
| 2003.1.2 11:12PM | 2003-1-2T11:12PM | 20030102 11:12PM |
| 2003.1.2 11:12:13.14mm | 2003-1-2T11:12:13.14mm | 20030102 11:12:13.14mm |
| 2003.1.2 11:12:13xxxx | 2003-1-2T11:12:13xxxx | 20030102 11:12:13xxxx |
| 2003.1.2 11:12xxxx | 2003-1-2T11:12xxxx | 20030102 11:12xxxx |
| 2003-1-2 11:12:13.14 PM | 2003 1 2 11:12:13.14PM | 2003年1月2日 11:12:13.14PM |
| 2003-1-2 11:12:13 PM | 2003 1 2 11:12:13PM | 2003年1月2日 11:12:13PM |
| 2003-1-2 11:12 PM | 2003 1 2 11:12PM | 2003年1月2日 11:12PM |
| 2003-1-2 11 PM | 2003 1 2 11 | 2003年1月2日 11PM |
| 2003-1-2 11:12:13.14PM | 2003 1 2 | 2003年1月2日 11 |
| 2003-1-2 11:12:13PM | 2003 01 02 | 2003年1月2日 |
| 2003-1-2 11:12PM | 2003 1 11:12:13.14 | 2003年1月2 |
| 2003-1-2 11PM | 2003 1 11:12:13 | 2003年1月 |
| 2003-1 11 | 2003 1 11:12 | 2003年1月 11:12:13.14 |
| 2003-2 11:: | 2003 1 2 11:12PM | 2003年1月 11:12:13 |
| 2003-2 11::13 | 2003 1 11 | 2003年1月 11:12 |
| 2003-1-2 11::13.14 | 2003 2 11:: | 2003年1月 11 |
| 2003-1 ::. | 2003 2 11::13 | 2003年2月 11:: |
| 2003-1 :: | 2003 1 2 11::13.14 | 2003年2月 11::13 |
| 2003-1 : | 2003 1 2 11:12:.14PM | 2003年1月2日 11::13.14 |
| 2003-1-2 11:12:.14PM | 2003 1 2 11PM | 2003年1月2日 11:12:.14PM |
| 2003-1-2 11::13.14 | 2003 1 2 11:12PM | 2003年1月2日 11PM |
| 2003-1-2 11:12:.14PM | 2003 1 2 11:12:13.14mm | 2003年1月2日 11:12:13.14mm |
| 2003-1-2 11PM | 2003 1 2 11:12:13xxxx | 2003年1月2日 11:12:13xxxx |
| 2003-1-2 11:12PM | 2003 1 2 11:12xxxx | 2003年1月2日 11:12xxxx |
| 2003-1-2 11:12:13.14mm | 2003 1 2 11xxxx | 2003年1月2日 11xxxx |
| 2003-1-2 11:12:13xxxx | ||
| 2003-1-2 11:12xxxx |
Long date string as follow:
| Monday, March 22, 2010 |
| 22 March 2010 |
| 星期一, 22 三月, 2010 |
| 2010年3月22日 |
| lundi 22 mars 2010 |
| Montag, 22. März 2010 |
| 22 марта 2010 г. |
Timezone string as follow:
GMT +0800, gmt-0800, -0500, +0500, +13:00, -13:00, UTC0800, utc-0600
Friendly blog links:
- Convert Date and Time in Excel 2010 by Usman
for empty category blog or list
There are no articles in this category. If subcategories display on this page, they may contain articles.