I have a spreadsheet that is exported from another system. The numbers
in it are exported as text with leading zeros. I can convert this text
to numbers from within the worksheet using the function =value(), but I
want my macro to convert them automatically. I do not want to move the
data from the current cells, just convert it to numbers so that it can
be totalled. What is the correct command/syntax for this?

Try something like this using DB as the range you want to change:

Dim CellRge as object
For Each Cellrge in DB
cellrge = val(cellrge)
Next CellRge







"RobH" wrote in message
ups.com...
I have a spreadsheet that is exported from another system. The numbers
in it are exported as text with leading zeros. I can convert this text
to numbers from within the worksheet using the function =value(), but I
want my macro to convert them automatically. I do not want to move the
data from the current cells, just convert it to numbers so that it can
be totalled. What is the correct command/syntax for this?