I need a quick solution to this.
I have a large EXCEL 2010 spreadsheet imported from a pdf file which contain a large amount of numbers stored as text.
Is there a quick way to select this numeric text and turn it into numbers?
Selecting a range of cells and choosing format cells does not appear to work.
I know it can be done cell by cell but this would take forever.