2 Replies Latest reply: May 15, 2014 10:15 AM by DD _ RSS

    Checking to See if Field Contains a Number

    DD _

      Is there a function that will tell me if  the data in a field is a number.  The field is formatted as "General" and the field is a calculated field. What I'm trying to do is only display data in this field if it is a number.

       

      Here is the formula that I am using... not that this is going to help but I want to add another condition around it so I only have numbers in this field. 

       

      IF(LEFT(A,1) <> "", SUBSTR(A,22,5),"")