How can I Formati a column to show a reading age as YY/MM

[Paulet]

Hi I'm struggling to change the format of my information to show reading ages in the YY/MM range. I already have info and when I custon and change to YY/MM it changes all the years to 19 from any year age ie 10/11 = 10yrs 11 monthes. but when I custom format the cell it changes to 19/11 - any ideas. I wasting to much time that I don't have on trying to work this out my self - fingers crossed and thank you for reading my thread

 

[alansidman]

This can be easily accomplished using Power Query. Load your file to PQ. Split your column based upon the delimiter "/". Then merge your columns back using separator yrs. Then add months to the column using concatenate. Go to Home and Load and Close .

 

[steve the fish]

If it is changing all years to 19 then when you enter the 10/11 excel is converting it to a date, presumably 10/11/2019. Formatting then to YY/MM will produce 19/11 depending on your date locale. Format these cells to number. What is showing in the cells?

 

[Paulet]

This can be easily accomplished using Power Query. Load your file to PQ. Split your column based upon the delimiter "/". Then merge your columns back using separator yrs. Then add months to the column using concatenate. Go to Home and Load and Close .

that's brilliant - thank you so much for your help and more importantly giving me time back in my day. kind regards