Hi Clay,
I have a similar situation. But I can't change the field type in SP to text because it is being used for calculations. Further, my field is a text field, but it is a drop-down list box. When the field was not a drop-down list box, I used the substring function to format, but this does not work for drop-down list boxes. Do you know how to get rid of the decimal and trailing zeroes in all of the numeric values in a drop-down list? I am using SP 2007 and InfoPath 2010. Thank you!