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?