Thousands Separator with High Numbers

Maerawlings

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)

Craige_Hales

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.