I have a calculation which gives with numbers up to 1,000,000,000. For numbers less that one it puts the information in the correct format. However for the number one I am getting 1.0e+9. I changed the formatting so that the field is showing the number 1000000000 to the user. However, when you click on the field the database is still storing the number as 1.0e+9. What this means is that when I do a text calculation putting all my data fields side by side I am getting the 1.0e+9 in my text field, rather than the 1000000000 in my calculation. Is there away around this problem.
I hope that my question is clear.