Function "Type" does not work properly
Posted by Al on July 05, 1999 10:41 AM
The "Type" function does not return 8 but 1, even in the reference cell I have a formula and not a number. As I know Microsoft has only acknowledged the bug but they do not have any solution. Do you know a workaround. I tried to create a conditional formula like; if in cell A1 there is the character =, return "formula", if not other, but it does not work. I cannot find a way Excel to recognize = sign. Any suggestions? Thank you.