Skip to main content

Kutools for Excel 29.10 HOT

300+ Powerful Features You Must Have in Excel

Kutools-for-Excel

Kutools for Excel is a powerful add-in that frees you from performing time-consuming operations in Excel, such as combining sheets quickly, merging cells without losing data, pasting to only visible cells, counting cells by color and so on. 300+ powerful features / functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 or Office 365!

Read More Download Buy now

Office Tab 15.00HOT

Adding Tabbed Interface for Office

Office Tab

It enables tabbed browsing, editing, and managing of Microsoft Office applications. You can open multiple documents / files in a single tabbed window, such as using the browser Chrome, Edge, and Firefox. It's compatible with Office 2021, 2019, 2016, 2013, 2010, 2007, 2003 or Office 365. Demo

Read More Download Buy now

Kutools for Outlook 17.00NEW

100+ Powerful Features for Outlook

Kutools-for-Outlook

Kutools for Outlook is a powerful add-in that frees you from time-consuming operations which majority of Outlook users has to perform daily! It can save your time from using Microsoft Outlook 2021, 2019, 2016, 2013, 2010 or Office 365!

Read More Download Buy now

Kutools for Word 10.00NEW

100+ Powerful Features for Word

Kutools-for-Word

Kutools for Word is a powerful add-in that frees you from time-consuming operations which majority of Word users have to perform daily! It can save your time from using Microsoft Word / Office 2021, 2019, 2016, 2013, 2010, 2007, 2003 or Office 365!

Read More Download Buy now

Quickly identify and convert date format in Excel

Kutools for Excel

Boosts Excel With 300+
Powerful Features

In Excel, you may need to convert the dates stored as text into date formats or identify various non-standard dates as the locale date formats according to your operating system settings. Kutools for Excel’s Convert to Date can help you quickly apply following operations in Excel.

Convert dates stored as text into the local date formats

Convert date formats into the local date formats

Convert long date formats into local short date formats

Convert non-standard date formats into local date formats


Click Kutools > Content > Convert to Date. See screenshot:

shot convert date format 1


Usage:

1. Select the range that you want to apply this utility.

2. Then apply the utility by clicking Kutools > Content  > Convert to Date. See screenshots:

shot-convert-date-format-2 arrow-big shot-convert-date-format-3

3. All of the dates stored as text or non-standard date formats will be converted to your local date formats.

Note: If you don’t want to convert some specified dates in the range, please hold down CTRL key to select or highlight them in the Convert To Date dialog box, and then click Recover button to stay unchanged them.


Convert dates stored as text into the local date formats

Supposing you have a range of dates stored as text in your workbook, you can apply Convert To Date to convert them into date formats.

shot-convert-date-format-4 arrow-big shot-convert-date-format-5

Convert date formats into the local date formats

This utility can also convert various date formats into your local date formats according to your operations system settings.

shot-convert-date-format-6 arrow-big shot-convert-date-format-7

Convert long date formats into local short date formats

shot-convert-date-format-8 arrow-big shot-convert-date-format-9

Convert non-standard date formats into local date formats

shot-convert-date-format-10 arrow-big

Demo: identify and convert date format in Excel


Kutools for Excel: Over 300 handy tools at your fingertips! Start your 30-day free trial with no feature limitations today. Download Now!

Productivity Tools Recommended
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.

Kutools for Excel

The functionality described above is just one of 300 powerful functions of Kutools for Excel.

Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 30 days.

Screen shot of Kutools for Excel

btn read more      btn download     btn purchase

Comments (3)
No ratings yet. Be the first to rate!
This comment was minimized by the moderator on the site
I am only able to use the Convert to Date one time in a session. So if I open a new workbook - and I have already used the Convert to date function - it does not work. Please fix. This is a useful tool in my job.
This comment was minimized by the moderator on the site
Change time
This comment was minimized by the moderator on the site
The dates I have are 2014/11/25 07:31:25 PST I need to convert them to date format but adjust per timezone So this SHOULD convert to 2014/11/25 05:31:25 Can the product handle time zone conversions to TZ of that excel is running in?
There are no comments posted here yet
Please leave your comments in English
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations

Tips and Tricks

Feature Tutorials