Value(left(0.5,4)) returns 0 when expecting 0.5

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?


Hi @Jason_Calaiaro - your formula works fine for me:

Combo field is:

VALUE(LEFT(Name, 4))

Make sure the formatting on the field is set to decimal


1 Like