How do I convert a text date in excel from dd.mm.yy to dd/mm/yyyy? and have the new dd/mm/yyyy cell an actual date cell?
Excel – How to convert a text date in excel from dd.mm.yy to dd/mm/yyyy
microsoft excel
Related Solutions
What you want is to use a custom format. Just type it in the box.
Select the entire column with the dates stored in them, right click on the selection, choose Format Cells, then set this to date.
They should now be converted to dates, and your formulas will work.
Best Answer
A2you have written a date like,13.12.2017and it's format is Text.So to convert into
dd/mm/yyyy, you can use the following.You get
13/12/2017.A2has13.12.20, then you should have to use this formula.=LEFT(A2,2)&"/"&MID(A2,4,2)&"/"&RIGHT(A2,2)You get
13/12/20.