Hi All,

I wish to apply a =cint() vba command to a range of cells in one column
without having to loop through each cell as this takes time. Is there any
easy way to do this? I tried to do a range().value = cint(range().value) but
this didn't work and neither did many other things I tried

Problem is i dump data into a sheet from a database query and excel thinks
the numbers are text - formating them to number will not work, only going
through and converting the values will, hence my need to have a fast way of
powering through many lines in one go than going through one by one in a
loop.

Help is appreciated and i extend my thank you in advance.

Regards,
Clint