MrExcel Publishing
Your One Stop for Excel Tips & Solutions

html past into excel

Posted by Miguel on February 12, 2002 11:10 AM

I am trying to past my expense report that I retrieve from my intranet web site in html form in to excel which work perfectly but I'm unable to manipulate any of the data. ex: would be numeric fields want sum or do any arthimatic functions?

any help would be appreciated

Posted by Mark W. on February 12, 2002 1:24 PM

There's probably some special (unseen) characters
that are causing your number to be treated as
text. Use this formula...


to obtain the ASCII coding of your value. Enter
it into an unused cell on your worksheet. Change
the "A1" to a cell reference of one of your
numeric values. Click on the formula bar and
press F9. Paste the resulting array constant
(e.g., {50;53;32}) into a reply posting.

Posted by Joe Clement on February 13, 2002 11:18 AM

I didn't post the original question but I'm having the same problem. I've followed your instructions and got this: ={160;54;51;48}

(the original value in the cell was: " 630")

What do I from here?