P
Pierre
Have a formula
What I would like: ,IF(COUNTIF(A1,"*"&{.124}&"*"),"yes"
Excel "insists on placing a zero" before the dot in front of the 124
What it changes to by pressing enter:
,IF(COUNTIF(A1,"*"&{0.124}&"*"),"yes"
I need the dot in the formula as to only check if the "124"
immediately follows the dot, and not a 124 which may occur someplace
within the cells contents. If I leave the zero in the formula, if
does not return the correct answer.
Is there a way around this apparent quirk?
Thank you.
pierre
What I would like: ,IF(COUNTIF(A1,"*"&{.124}&"*"),"yes"
Excel "insists on placing a zero" before the dot in front of the 124
What it changes to by pressing enter:
,IF(COUNTIF(A1,"*"&{0.124}&"*"),"yes"
I need the dot in the formula as to only check if the "124"
immediately follows the dot, and not a 124 which may occur someplace
within the cells contents. If I leave the zero in the formula, if
does not return the correct answer.
Is there a way around this apparent quirk?
Thank you.
pierre