Whether it succeeds will depend on the text value you are trying to convert.ĭate problems often occur when you import data from a CSV file (which is a text file format) and Excel doesn't recognise the dates in the file so it imports them as text instead. The DATEVALUE function takes a text value and tries to convert it into a date. ![]() Use the DATEVALUE function to convert text to a date. This lesson looks at several ways you can convert a date which Excel is treating as text into a proper date value in Excel. For example you can't sort by date properly. When that happens, Excel can treat those dates as text - in other words, they look like dates but don't behave like dates. ![]() ![]() Sometimes you'll find yourself working with dates in an Excel spreadsheet that have been pasted or imported into Excel from another datasource.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |