VALUE error after pasting html banking data
 

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?

VALUE error after pasting html banking data
 

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

On Dec 19, 6:12*pm, exceluser
wrote:
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?

VALUE error after pasting html banking data
 

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

"Pete_UK" wrote:

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

On Dec 19, 6:12 pm, exceluser
wrote:
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?

VALUE error after pasting html banking data
 

Well, glad to be of help.

Pete

On Dec 19, 7:01*pm, exceluser
wrote:
Wow, I never would have figured that out. Thanks, that was driving me nuts!



"Pete_UK" wrote:
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

On Dec 19, 6:12 pm, exceluser
wrote:
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?- Hide quoted text -

- Show quoted text -