Try selecting an empty cell.
Edit|Copy
Select your range of offending text numbers.
Edit|Paste special|select Values and Add.

This won't make your values integers, but will convert the text numbers to
number numbers.

If you need a macro, you can record one when you do it manually.

Clinton M James wrote:

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

--

Dave Peterson