Convert Date and Time in Excel 2010

Writing dates and time values in spreadsheets are always very tedious because of standards to comply. Excel Date/Time Converter is very useful add-in which lets you convert values into date/time format instantly. It supports multi-languages, so you can also convert dates and time written in other eminent languages. Unlike others, It sports direct integration into Excel.

After successful installation, launch Excel 2010, you will see a new tab Tools appear on the ribbon.

Write data in any format to check out the results. Select the cell which contain value in Date & Time format and click Convert to DateTime.

conversion complete 1

Upon click Converted result dialog will appear, showing you the result. If the conversion is successful, you will see the green tick sign. On failure you can also see the results which have failed during the process of conversion. Click Close to see the results in Excel sheet.

converted result

It also allow users to undo the conversion. Right-click on the converted Date/Time values and hit Undo convert.

undo convert

As you can see in the screenshot below that values have been successfully converted.

date 7 time

It is also supports multi-languages, if you are well-versed in other languages, you can also play around with it, by writing date/time format values and converting them.

For detailed illustration of different examples and scenarios, check out product page.

Download Excel Date/Time Converter

It supports both Excel 2007 and Excel 2010.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *