I am grabbing XML data into text fields.  Most data is text, but some is actually numbers.  I need to be able to take two fields, which are text, but are "decimal text".  By this I mean the data is stored in a text field, but its stored in decimal format.

For example - in my field called "text1" the value is 907.52

                   - in my field called "text2" the value is 925.72

I need to convert those text fields into integer fields, and remove everything to the right of the decimal point, thus creating whole numbers, 908 (rounded), and 926 (rounded), respectively.

I then need a formula field to calculate text2 - text1 (this part I have figured out)

So, to summarize:

I need to convert 2 text fields into numbers field, and then remove the decimals by rounding up, so I then can subtract values of the two fields.  I was able to convert text (that wasnt a decimal) to a number using .toLong(), but thats not working with the decimals...

Help me please, I'm ready to lose my mind.