You have to use "text to columns" command on the ribbon to change the format. Unfortunately I have polish version of excel so it could be difficult to explain.