VB code - convert numeric text to values.

[thunderfoot]

I have a spreadsheet into which a numeric table has been imported from a PDF file. All the numeric values in this table are showing as text entries now it's in EXCEL.
I could use the VALUE() function to convert all cells to Numeric Values, but just wondering if it's possible to run a small VBA routine to convert numeric numbers shown as text to values?

Say, the table is in cells A1:Z60.

 

[Colin Legg]

Hi,

A non VBA option:

Type in 1 into an empty cell.
Copy it.
Select the range A1:Z60
Right click | PasteSpecial
In the Operation frame, select the Multiply option.
Click on OK.
Clear the 1 out of the empty cell.