View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
rkd
 
Posts: n/a
Default Replacing characters in numeric text strings and SUMming


The dollar and parentheses are part of the text strings in the example,
so from what I can tell they need to be stripped
out and the numbers in parentheses converted to negative before the
formulae above will work!?

Also, as I said above, I need to keep the original cells as they are
with the dollar sign and parentheses.

thanks again.