Formatting options for very large numbers

Bob over 8 years ago

I am looking for formatting options for very large numbers - I was originally saving the data as an integer value which I could have formatted with text(), but the requirement for one field exceeds what an integer can handle ("we have programs with over 25,000,000,000 records"). I switched that number to a text field but would like to be able to reformat entries with commas if possible so people can verify their entries.

Discussion posts and replies are publicly visible

Top Replies

Stefan Helzle over 8 years ago +1
A Score Level 3

From my experience you can use text() to format large decimal numbers but you have to add more "#" characters. =text(99999999999999.0, "###,###,###,###,###.##") -> 99,999,999,999,999.00 but =text(99999999999999…

Parents

0 Bob over 8 years ago

Interesting. I am seeing just what I need from both the fixed() and tointeger() functions, despite the documentation. Fixed() should take a decimal number input according to the documentation but seems perfectly happy with text and tointeger() has no problem with very large text numbers (as long as the output is saved in a text field).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Bob over 8 years ago

Interesting. I am seeing just what I need from both the fixed() and tointeger() functions, despite the documentation. Fixed() should take a decimal number input according to the documentation but seems perfectly happy with text and tointeger() has no problem with very large text numbers (as long as the output is saved in a text field).
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data