user297850
Reputation: 8005
Transform an input with "month year" to "month/year" in R
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?
Upvotes: 0
Views: 47
Answers (1)
ZygD
Reputation: 24356
In Excel the following formula will do the trick:
=TEXT(A1,"mm/yyyy")
Upvotes: 1
Related Questions
- Unable to convert Month-Year string to Date in R
- How to change "year.month" format into "Year-Month" format in R
- How to format monthly variable from year/month numeric variable (R)
- Converting string into year-month in R?
- Convert decimal month and year into Date
- Convert character month column into year-month format in R
- How to convert a date with only a year to a date with the format "Year-Month-Day" in R
- changing date format with only months and year
- convert characters to month and year ( date ) in R
- Changing "Month Date" to "Year-Month-Date" in R