the likes of:


VBA Code:
--------------------


Range("A1:M200")=Range("A1:M200").value
--------------------



seems to work here.


JoeBoynton;705352 Wrote:

Hi,
I need help on how to automate the conversion of a range of Excel cells
from
text to numbers. I'm using Excel 2007 to test, VB.NET 2005 and Excel
9.0
Object lib. I've read some rows of data into an array and I set my
Excel
Range = to the array which copies everything in quickly which is what I
want.
Cell by cell is very slow with a hi number of records. Everything is
fine,
except the cells with numbers were copied as text and those cells have
warning flags in the corner with the first 2 options in the dropdown
being:
"Number Stored As Text" and Convert To Number". Clicking on Convert to
Number, or even clicking inside the cell a couple of times and then
outside
fixes the problem and you can tell cause the warning is gone and
numeric
formatting is applied. How can I automate this ConvertToNumber in code.
If
I create thousands of these cells, the user can't be expected to convert
each
one manually and I need to automate it. All my searches have netted
zero,
zilcho, nada. Is there some hidden method somewhere that allows me to
convert a range or even loop thru the range cell by cell and convert
the
value of each of these cells to Number instead of Text? Your help would
be
appreciated.


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=197375

http://www.thecodecage.com/forumz