Thread: VALUE error after pasting html banking data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ExcelUser ExcelUser is offline
external usenet poster
  
Posts: 41
Default 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?

Reply With QuoteReply With Quote