0

If a time-related information is read as "Jun 2008". Are there any convenient approaches to transform it into date format in R or Excel, i.e., 06/2008?

ZygD
  • 22,092
  • 39
  • 79
  • 102
user297850
  • 7,705
  • 17
  • 54
  • 76

1 Answers1

1

In Excel the following formula will do the trick:

=TEXT(A1,"mm/yyyy")
ZygD
  • 22,092
  • 39
  • 79
  • 102