Skip to Content
Former Member
Jun 15, 2009 at 02:12 AM

How to manipulate a number from a string


Hi All

I am using CRXI and have designed a report that will list all of our fleet starting with the 'Fleet No.' The fleet no. field is a string so that the fleet no.s weren't displaying in numerical order. I converted the field to a number and it then worked fine. Now, of course, the boffins have decided to create new fleet no's '7110.1'. With the field being a number these weren't displaying on my report. I thought if I played with the 'decimal points' that would help. My report now has '101.0' instead of '101' as well as displaying '7110.1'. Is there a formula to suppress the decimal point if it is zero?

Thanks in advance for your help