Hi All,
I have a column of numbers (5 or 6 digits) which represent month and year
E.g. 20091 = January 2009, 201112 = December 2011, and so on.
Is there any way I can convert this back into MMYYYY form?
Alternatively, I have this problem because I needed to create a pivot table in ascending order going by months of the year which required 'grouping' the various dates (DD-MM-YYYY). The only way I found I could do this was to use =VALUE(CONCATENATE(YEAR(F2),MONTH(F2))), which gave me this problem of 20091, etc in the first place.
Any one have suggestions?
Bookmarks