I've copy/pasted the web page array of the details of my phone calls
from my on-line verizon cell phone bill into an Excel worksheet. The
number shown for the minutes of duration of each call doesn't equate
to an Excel number and the SUM() function reports zero. What's a line
of code (or other process) that will convert these numeric-appearing
entries into actual numbers? The text in the editing bar is two
spaces followed by a cipher, e.g. " 1" for one minute, so that the
cipher appears just to the right of center.

Neither of the following work. They both convert to the number zero
instead of to the actual number of minutes.

ActiveCell.Value = Val(LTrim(ActiveCell.Value))
ActiveCell.Value = LTrim(ActiveCell.Value)

Using ActiveCell.Text for the right-hand expression also doesn't seem
to work.

The cell formatting in the column has been converted to number, zero
decimal places.

Thanks for any help.

Fred Holmes