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
  • The numbers you calculate on are decimal, right? Then this is just a matter of display. This is why I suggested to use text() for showing the numbers to the user. Try this:

    =with(
    local!number: 1234567890.1234,
    local!number & char(13) &
    text(local!number, "### ### ### ###.##")
    )

    Result is:

    1.234568e+009
    1 234 567 890.12
Reply
  • The numbers you calculate on are decimal, right? Then this is just a matter of display. This is why I suggested to use text() for showing the numbers to the user. Try this:

    =with(
    local!number: 1234567890.1234,
    local!number & char(13) &
    text(local!number, "### ### ### ###.##")
    )

    Result is:

    1.234568e+009
    1 234 567 890.12
Children
No Data