Skip to main content
Web Applications

Return to Question

Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
edited title
Link
marikamitsos
marikamitsos
  • 13.1k
  • 4
  • 34
  • 59

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

deleted 7 characters in body
Source Link
serenesat
serenesat
  • 10k
  • 30
  • 33
  • 50

I have recievedreceived 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? Thanks

example

I have recieved 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? Thanks

example

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

Source Link
Joan MITJANS
Joan MITJANS
  • 21
  • 1

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

I have recieved 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? Thanks

example