AnsweredAssumed Answered

Number formatting

Question asked by LadyBear on Dec 9, 2013
Latest reply on Dec 12, 2013 by LadyBear

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.

Outcomes