I do not have my laptop with me at the moment but what I do to change text to numbers is to select a blank cell>copy>select the range to be converted>paste special>add.