Macro to convert text/numbers to numbers

Hi all,

I am extracting a large set of numbers forming various tables from SAP. These numbers are not recognized as numbers and have Formula error. Only way to further process them is to convert them to number using 'Error Checking' option from 'Formula' Tab.

I need a macro to convert all such text to numbers, note there are no other formula errors.

I have other macro to delete rows, columns, take sum and create new Summary Table from the data but that does not work until I manually convert text to numbers.

Can anybody also suggest how to have the macro globally i.e, I need to only open the extracted data in excel and be able to run the Macros. Presently I open the extracted data and also open the master macro-enabled file to access the macro.

Thanks in advance,

Paresh

A macro like this perhaps?

Please Login or Register  to view this content.

Alf