Question on avoiding exponential format in numbers

I have a requirement where I have to perform different type of validations (onscreen) based on calculations that involves 10 digits up to 2 decimal places (ex: 8542137887.12). when I am trying to achieve same using decimal data type it is getting converted into Exponential format. can any one suggest me some workaround?

Note: calculations involve multiplication, division addition and subtraction.

OriginalPostID-199279

OriginalPostID-199279

  Discussion posts and replies are publicly visible

Parents
  • What datatype do you use in the DB field? If decimal (float in MySQL) then it will just save the number as it is. If it is text, then it will save "1.234568e+009" by default, because this is how decimal numbers are formatted. You can change that by using the text() function.
Reply
  • What datatype do you use in the DB field? If decimal (float in MySQL) then it will just save the number as it is. If it is text, then it will save "1.234568e+009" by default, because this is how decimal numbers are formatted. You can change that by using the text() function.
Children