View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brad[_2_] Brad[_2_] is offline
external usenet poster
 
Posts: 1
Default Value of String used in Calculation?

I have a basic formula (using basic math operators, no excel calls) that is
being impacted by a 'general text' value in a field. So, if my formula is
A1/A2*A3, I will get a different answer if A1 is 0 vs some random text.
Should I expect text in a field to actually be converted to some value in a
calculation? Is there a way to get it to not do that?
--
Brad Eck
<a href="http://www.sitesdynamic.com"SitesDynamic</a
<a href="http://www.eternalelement.com"Eternal Element</a
<a href="http://www.basketsetcetera.com"Baskets Etcetera</a