Skip to main content
2 of 3
deleted 7 characters in body
serenesat
  • 10k
  • 30
  • 33
  • 50

Add '/' character in between a number (which should be formatted as a date)

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?

example