topic Re: Help with changing default Scientific notation to user defined scientific notation in Discussions

Help with changing default Scientific notation to user defined scientific notation

chemguy — Mon, 28 Oct 2013 15:50:27 GMT

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

Re: Help with changing default Scientific notation to user defined scientific notation

Jeff_Perkinson — Tue, 29 Oct 2013 13:55:16 GMT

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

Re: Help with changing default Scientific notation to user defined scientific notation

chemguy — Tue, 29 Oct 2013 13:56:38 GMT

Thanks Jeff