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 Stefan Helzle
A Score Level 3
over 8 years ago

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.0, "##.##") -> 214748364799.00
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Stefan Helzle
A Score Level 3
over 8 years ago

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.0, "##.##") -> 214748364799.00
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data