That apostrophe before the date is used to indicates to Excel that the value in the cell is text value, regardless of what it looks like. Second, you'll notice when you click on a cell containing a date that it contains a value such as '8.First, some or all of the dates will be left-aligned in the cell.Two tell-tale signs that you have a date problem are as follows. Another scenario is when you copy and paste date values into Excel from another file format. 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. |