VALUE error after pasting html banking data

[exceluser]

When I paste my online banking data into excel 2007 and try to use the values
in a formula I get a VALUE error. I tried changing the cell formatting to
currency but the cell values don't update to the new format automatially. Why
does this happen and how do I avoid the error?

 

[Pete_UK]

Often when you paste data into Excel (from an HTML source) you bring
with it some non-breaking space characters, with a code of 160. To get
rid of them you can highlight the offending cells (or columns) and
CTRL-H (Find/Replace):

Find what: Alt-0160
Replace with: leave blank
Click Replace All

where Alt-0160 means that you hold down the Alt key while typing 0160
on the numeric keypad.

Hope this helps.

Pete

 

[exceluser]

Wow, I never would have figured that out. Thanks, that was driving me nuts!

 

[Pete_UK]

Well, glad to be of help.

Pete

Wow, I never would have figured that out. Thanks, that was driving me nuts!








- Show quoted text -