Note: The other languages of the website are Google-translated. Back to English
English English

Kutools for Excel 26.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 14.50HOT

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 IE 8/9/10, Firefox, and Google Chrome. It's compatible with Office 2021, 2019, 2016, 2013, 2010, 2007, 2003 or Office 365. Demo

Read More Download Buy now

Kutools for Outlook 16.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

Tips and Tricks

Feature Tutorials

Quickly identify and convert date format in Excel

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

Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
  • Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future.
  • More than 20 text features: Extract Number from Text String; Extract or Remove Part of Texts; Convert Numbers and Currencies to English Words.
  • Merge Tools: Multiple Workbooks and Sheets into One; Merge Multiple Cells/Rows/Columns Without Losing Data; Merge Duplicate Rows and Sum.
  • Split Tools: Split Data into Multiple Sheets Based on Value; One Workbook to Multiple Excel, PDF or CSV Files; One Column to Multiple Columns.
  • Paste Skipping Hidden/Filtered Rows; Count And Sum by Background Color; Send Personalized Emails to Multiple Recipients in Bulk.
  • Super Filter: Create advanced filter schemes and apply to any sheets; Sort by week, day, frequency and more; Filter by bold, formulas, comment...
  • More than 300 powerful features; Works with Office 2007-2019 and 365; Supports all languages; Easy deploying in your enterprise or organization.

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 includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial 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 60 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
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?
This comment was minimized by the moderator on the site
Change time
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.
There are no comments posted here yet
Leave your comments
Posting as Guest
×
Rate this post:
0   Characters
Suggested Locations