Posts by RBX

    i created an IF function that chooses between a set number of values the problem is that source values are writen in inches(with the inch symbol "")my problem is that excel is no longer reognizing the values as numbers i cant control the way the values because they are linked to an outside CAD program(hence why they apper with the inch symbol)

    in short this what appears in the reference cell-->5.000" but in formula i want excel to ignore the " symbol and start seeing the number 5 and not a text!

    thanks in adavance:)