Question: how to convert yyyymm to date in excel?
Answer: Now you can use the format cell dialog box to format date as you want. Just select the B1 cell and press CTRL + 1 keys together then you need to go to number tab which is by default select. Now select custom from Category list box and type the yyyy,mm in type text box. Refer below screen shot.