Issue with Value() function converting string to number
I am using a switch formula to simplify and bucket a column of mixed numeric and text values. The goal is to simplify values that are numeric with text to just the number. (For example, I have these values in the column: "2", "2g", "2 g" and I want all of them to be returned as "2".) There are some values in the column that do not have any numbers such as "dg" and "ph". I used the formula ISERROR(VALUE([mycolumn])) within my switch formula to return a value of "Other" for these values. The problem is with one single row that has the value "2a". This does NOT return as an error within the VALUE() function. It actually returns a value of 0.0833333 for a reason I can't figure out. Is "a" some stored variable? What is going on and how can I fix it??
