VBA to convert range to number

[Curtisyoung78]

I am trying to find a vba code that will convert a range to numbers, the range is C12:I2500. I've tried a few things that i know but no luck. Can someone help?

 

[oldbrewer]

are they text = 99 or text = ninety nine........or something else

multiplying all by 1 is a start

 

[Engineer Joe]

you mean like this?

Range("C12:I2500").NumberFormat = "@"

 

[Curtisyoung78]

are they text = 99 or text = ninety nine........or something else

multiplying all by 1 is a start

it was Text=99 and multiplying by 1 did the trick, thanks oldbrewer!

 

[oldbrewer]

glad to help