How to convert string to number with decimal points

Hello, I have a requirement to create a number with 2 decimal points from a string field.

e.g.

'9079' to '90.79'

Also the length of the string is not always the same

any suggestions would be greatfully appreciated

Steve

Developer

Accepted answers

Wouldn't the easiest way be to convert the field into a number and then just divide by 100?

Wouldn't the easiest way be to convert the field into a number and then just divide by 100?

Hi, many thanks for that a very easy answer to my problem

regards

steve