![]() Select the cell B1 and right-click, choose Format Cells from the context menu. This is the correct answer, but it has the wrong format. Then press Enter key, the formula returns a number 41317. In the adjacent cell B1, enter the formula = Datevalue(A1), see screenshot:Ģ. You can convert this text dates to Excel date as following steps:ġ. When you input '1 into a cell, that apostrophe before the date is used to indicate to Excel that the value in the cell is text value (see following screenshot). Here I will talk about using DateValue function to change the text dates to proper Excel dates. ![]() ![]() How could you change these strange date formats to the Excel standard date?Ĭonvert dates stored as text to normal Excel date with formulaĬonvert numbers to normal Excel date with Text to Columns functionĮasily convert various non-standard dates to normal Excel date with Kutools for Excel Excel doesn’t recognize them and you can’t use them for any calculation purpose or change their format as you need. Maybe you have encountered with various non-standard date formats when you use the Excel workbook. How to convert various non-standard date formats to standard date in Excel?
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |