| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pasting a html table into excel | Excel Discussion (Misc queries) | |||
| Pasting HTML into the cells in column A | Excel Worksheet Functions | |||
| Pasting HTML into a single cell | Excel Discussion (Misc queries) | |||
| .. any help appreciated .. i think it's a pasting HTML problem. | Excel Discussion (Misc queries) | |||
| Why can't I use SUM when pasting HTML code into new sheet. | Excel Worksheet Functions | |||
Linear Mode
