Macro for "Text to Column" operation in Excel 2010

Hi

I have a attached a file showing part of a spreadsheet with numbers appearing as text. I can use the "Text to Column" operation to convert the text to numbers, but it allows me to do so column by column. When I have a number of columns it's a bit of a pain.

Is there code that can automatically do the conversion by column or the entire spreadsheet in one "go".?

Thanks

Patish

Perhaps,

Please Login or Register  to view this content.

Much appreciated there, Mike.