Excel - How to Convert Text to a Date

preview_player
Показать описание
In Excel, dates must be stored in a format that Excel understands otherwise Excel treats them as text (i.e. non-date) values. This video shows how to convert these "non-dates" to real dates which will then allow you to sort, filter and calculate.

This is a free lesson from my video-based training course "Excel - More Than a Numbers Game" in which you'll learn some simple-but-effective ways to save time when working with lists and text in general.

  1. Mike Thomas
  2. Excel
  3. Text
  4. Lists
  5. Database
  6. Concatenate
Рекомендации по теме
How to Convert 0:01:03

How to Convert Measurements in Microsoft Excel

How to Convert 0:00:47

How to Convert Minutes to Hours in Excel

HOW TO USE 0:05:04

HOW TO USE CONVERT EXCEL FUNCTION FOR VARIOUS UNIT MEASUREMENTS

Quick Way To 0:00:55

Quick Way To Change Text Case in Excel Without Formula - Excel Tutorials

How to Convert 0:01:18

How to Convert Word File to Excel

How To Convert 0:00:41

How To Convert Data in Columns into Rows in Excel Document

How to Convert 0:04:00

How to Convert Text to Number in Excel (Three Quickest Ways)

How to Convert 0:05:17

How to Convert PDF to Excel

How to Convert 0:02:33

How to Convert Excel to Google Sheets (Quick and Easy)

How to Convert 0:01:48

How to Convert Amount in Words in Excel (Spell Number)

How To Convert 0:01:12

How To Convert an Excel File into A MS Word Doc

Excel Tutorial - 0:02:35

Excel Tutorial - Convert formulas to values

Excel: How to 0:05:11

Excel: How to convert a number to text using the TEXT() function

How to Convert 0:01:19

How to Convert a CSV File to Excel

Convert XLS to 0:00:57

Convert XLS to XML (Excel to XML) - 2021

How to Convert 0:05:47

How to Convert Picture to Excel

How to Convert 0:01:15

How to Convert Horizontal Data into Vertical in Excel

How to Convert 0:01:29

How to Convert a Column to All Caps in Excel

How to Convert 0:05:24

How to Convert Text to Numbers in Excel

How to Convert 0:02:20

How to Convert PDF to Excel

How to Convert 0:00:57

How to Convert PDF to Excel from within Excel

How to Convert 0:00:27

How to Convert Excel to XML Format

How to Change 0:03:16

How to Change Negative Numbers to Positive in Excel

How to Convert 0:02:10

How to Convert Excel to JPG High-Resolution Image, XLSX to JPEG Photo converter HD Free

Комментарии
Автор

THIS IS THE VERY BEST VIDEO
THAT HELPED ME!

tommytwohands
Автор

You wouldn't believe how many hours I've been working on this and how many videos i watched on YouTube before I found this one! Thank you for clearly explaining this.

DrBrianLCarpenter
Автор

Mike, you saved my day.
I would like to thank you for your great video.

savwattson
Автор

OMG! Are you kidding me!?!?! I've been teaching Excel for 30 years and it never occurred to me to do this. I have this problem every so often in my classes and would have loved to show this to my students. Absolutely amazing! Thanks!

Sparqcorporatetraining
Автор

Great video. Simple but excellent explanation.

bilsaf
Автор

Thank you so much, you just saved my life.

diego
Автор

Great nice and clear thanks, just one question?
Does this only work with existing text?
It doesn't carry on working if you enter a different date later on - does that have to be some sort of formula?
Thanks again,

sojace
Автор

dont work...my colunm is text because i aplly the function type and the result was 2 but dont have '

oddnumber
Автор

no, there is absolutely no effect...why

andeslam