I have a unique problem I need solved.
I need to convert a column of general numbers to a date format. I have more than 100000 rows of this format I need converted.
I start with the following general format in the column
1150621
This number equates to 2015 June 21
I want it get it into 21/06/2015 format.
I have used this formula “=20&(REPLACE(LEFT(F6,3)&"-"&MID(F6,4,2)&"-"&RIGHT(F6,2),1,1,""))”
and got the following result
2015-06-21 (which looks like a date to me)
From there I cannot get Excel to format that as a date.
I have tried to copy and paste as value and then format it, cant get it right.
I am using Excel 2010 on Windows 7 Laptop.
Please help
I need to convert a column of general numbers to a date format. I have more than 100000 rows of this format I need converted.
I start with the following general format in the column
1150621
This number equates to 2015 June 21
I want it get it into 21/06/2015 format.
I have used this formula “=20&(REPLACE(LEFT(F6,3)&"-"&MID(F6,4,2)&"-"&RIGHT(F6,2),1,1,""))”
and got the following result
2015-06-21 (which looks like a date to me)
From there I cannot get Excel to format that as a date.
I have tried to copy and paste as value and then format it, cant get it right.
I am using Excel 2010 on Windows 7 Laptop.
Please help