In this publication titled how to change formatting from text to number in excel, I have provided a complete image from start to finish ,Please look below
