I have received a spreadsheet which has the dates formatted with only numbers without separators and I would like to transform them into a date format. For example, I would like to change the number 20201130 to 2020/11/30. How could I do it?
Add '/' character in between a number (which should be formatted as a date)
Joan MITJANS
- 21
- 1