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...
=CODE(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1))
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?
