Thousands Separator with High Numbers

[#1]

Hello! I have a Numeric Column which has up to 21 characters (i.e. 123145678915487615423) and I have the Column Properties set as:

Numeric

Continuous

Best

Width: 21

Use thousands separator checked

Unfortunately the highest character numbers are showing as 1.234567891546e+20

Where I want it to show as: 123,145,678,915,487,615,423

I tried to change many aspects, such as the modeling type, the format, data type, and the width.

Any help would be great! (I am using JMP17.0.0)

[#2]

You can do that, sort of. You might not want to because you might be suggesting non-existent accuracy.

format(123456789101112131415161718192021,"Fixed Dec", Use thousands separator( 1 ), 60, 0)
//    "123,456,789,101,112,139,099,124,663,320,576"

Notice there are only 15 to 16 significant digits; the remainder are garbage. This is a function of the IEEE 8-byte double precision floating point representation that can only represent an integer up to about 2^53==9007199254740992 (all 15 digit integers and most 16 digit integers.)

The 60, above, probably will break down around 100 as well. It does include the commas.

[#3]

Isn't width =21 insufficient for what you want?  I think (tell me if I'm wrong) that the commas count in the width.  Also (and I think this is the main issue) change the "Best" to "Fixed Decimal" and it should work.

[#4]

@dale_lehman: I tried both of your fixes and it does not work :( the characters are giving incorrect values when I use these fixes and the thousands separator does not show up.

Thanks for the attempt!

[#5]

It works for me - see attached.