Regrettably, the string to number or number to string functions available in Creo relations consist of ITOS() which converts a number into an integer string. Not very useful, I know. And it doesn't handle zero values properly.
If you already have a number in a string and the format is consistent, you might want to consider developing further relations to parse the string and "build" a numerical value. Simply stated, it'd be something like:
(1) Extract the part of the number before the decimal point.
(2) Process each digit of that to build the integer part of the real number.
value = ( rightmost digit ) * 1
value = value + ( 2nd digit from right ) * 10
value = value * ( 3rd digit from right ) * 100
.... etc.
(3) Extract part of the number after the decimal point.
(4) Process each digit of that to build the decimal part of the real number
value = value + ( leftmost digit ) * 0.1
value = value + ( 2nd digit from left ) * 0.01
... etc.
Not an elegant thing to do, and you need to be very careful about number formats (for example, does the number have a leading zero?).
If Creo had looping capabilities, this would be pretty easy, but it doesn't, so it'll be a lot of nested IF statements for sure.
