Convert numeric text to 4 digit decimal how? 2

[NewToThis2]

CV9. I have a long text field 00000000000115360+ in which I'm only using the ending digits less the +. For example, using the formula below, the above string would result in "115360". I then need this result converted to 11.5360

My formula thus far is:
strreverse(mid(strreverse({PERSACTION.NEW_VALUE_11}),2,6))

What do I need to add to the formula to convert the result into a 4 digit decimal?

Any help would be most appreciated. Thanks so much!

 

[SonOfZeus]

Have you tried to CDbl(number)/10000? If you convert to a number and then divide to get decimal places it should work.

 

[NewToThis2]

Thanks for the suggestion but I couldn't get that to work for me. Any other ideas?

 

[benniemi]

this should work for you.

tonumber(left ({PERSACTION.NEW_VALUE_11},length({PERSACTION.NEW_VALUE_11})-1))/10000

bennie

 

[NewToThis2]

I got the first one to work - thanks everyone!