Convert to a Number using VBA

[kjurcz]

I am looking to covert columns G:I (which may vary in length) from text to a number so that the columns will work with my excel formulas.

I should be able to figure this out but am having difficulty getting it to work.

Thank you!

[Richard Buttrey]

Hi,

The simplest way would be to enter a zero in a spare cell and copy it.

Then select all the cells in G:I and use Paste Special Add.
By adding zero to text 'numbers' you force them to become numbers proper.

[PeteABC123]

Type a 1 into an empty cell.
Copy.
Highlight the range that you want to convert to a number.
Paste special.
Multiply.
Click Ok.

They're numbers now.

Pete