Date Format Converter for Excel

Excel Date Format Converter boxDate 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.

 

excel date format converter screenshot

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.


  • Version: 1.20
  • Size: 9.18 KB
  • System: Windows XP/vista, Windows7
  • Requirement: Full version of Microsoft Office  Excel 2007, Excel 2010 installed
  • Category: Microsoft Office Add-in



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:

for empty category blog or list

There are no articles in this category. If subcategories display on this page, they may contain articles.