Help with changing default Scientific notation to user defined scientific notation

[#1]

Hi,

I need some help in  converting the following column of data (e.g. 2804504000) to User Defined Scientific format (e.g. 280.45E+6) instead of JMP default (2.805e+9). Is there any script I can use to change the Column Properties?

Thanks.

Original Data

2804504000

3195354000

3709419000

1422125000

3510051000

2892291000

JMP Default when you change the Format to Scientific

2.805e+9

3.195e+9

3.709e+9

1.422e+9

3.51e+9

Desired Output of data in fix Scientific format

280.5e+6

319.5e+6

370.9e+6

142.2e+6

351.0e+6

[#2 · Accepted solution]

Hi ChemGuy,

Unfortunately, JMP doesn't offer a way to change the number of digits to the right of the decimal in for Scientific format.

We'll consider this for a future enhancement though.

-Jeff

[#3]

Thanks Jeff