Formatting does not change the underlying cell contents, it is only a cosmetic change. You will need to convert the data.

upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.