View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
expect_ed expect_ed is offline
external usenet poster
 
Posts: 53
Default VALUE err calculating indirect number

shg - yes, =VALUE(INDIRECT(A10)) also gives the VALUE! error.

David - I think you are onto the problem, but how do I get rid of
non-breaking spaces formulaicly. I tried reading the web copy directly with:

=VALUE(TRIM(Sheet1!A61)) and it still gives me the VALUE! error.