Lucas in London
Board Regular
- Joined
- Jun 17, 2002
- Messages
- 88
Hi,
I have a spreadsheet I download that has dates stored in a non date format and I'm struggling to find an easy way to convert it to a format I can use.
The data is monthly and the dates are stored in the format: YYYY.MM - as shown for a sample of dates below:
2008.01
2008.02
2008.03
2008.04
2008.05
2008.06
2008.07
2008.08
2008.09
2008.1
2008.11
2008.12
I would like to conver these into the format: MMM-YY so for instance 2008.12 becomes Dec-2008 etc. I would usually use something like the text function (Text (value, "MMM-YY")) but this does not work has these entries are not recognised as dates! Anyone have any alternative ideas? The dates are in column A.
Thanks,
Lucas
I have a spreadsheet I download that has dates stored in a non date format and I'm struggling to find an easy way to convert it to a format I can use.
The data is monthly and the dates are stored in the format: YYYY.MM - as shown for a sample of dates below:
2008.01
2008.02
2008.03
2008.04
2008.05
2008.06
2008.07
2008.08
2008.09
2008.1
2008.11
2008.12
I would like to conver these into the format: MMM-YY so for instance 2008.12 becomes Dec-2008 etc. I would usually use something like the text function (Text (value, "MMM-YY")) but this does not work has these entries are not recognised as dates! Anyone have any alternative ideas? The dates are in column A.
Thanks,
Lucas