Am I doing something wrong here? For decimal values inside a string, “0.5 some text” or “12.1 some text”, when I use, Value(left(0.5),4), I do not receive the decimal value. It will return the first integer of number. Is there a different want to return the decimal number found on the left most side of the string as mentioned above?
J
