I have an excel file that a column with a date. the date is structured like this:20160711. I want the date to look like this: 07/11/2016 any easy way to do this?
Asked
Active
Viewed 117 times
-2
-
text-to-columns, fixed width, date:ymd, finish then format the cell as mm/dd/yyyy – Mar 09 '18 at 18:45
-
1You can use the formula that you can find here https://stackoverflow.com/a/13056198/1008588 – Nicolaesse Mar 09 '18 at 18:50
-
Thanks Jeeped. appreciate it – Mike F Mar 12 '18 at 16:12
1 Answers
0
From memory back in the Window's Days...
Select the Cells you want to format...
Right click >> Format Cells >> date
Select whatever format you like.
tony_felloni
- 61
- 5
-
-
-
so I have a column with probably 200 dates. the date is structured like this: 20160711 where yearmonthday. i want the date to look like month/day/month. i tried the format way and it's giving me bunch of error ###### – Mike F Mar 09 '18 at 18:52
-
This will not work as Excel see it as a number and not a date. The number is too large for a standard date. – Scott Craner Mar 09 '18 at 18:53