cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
chemguy
Level I

Help with changing default Scientific notation to user defined scientific notation

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

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson
Community Manager Community Manager

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

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

-Jeff

View solution in original post

2 REPLIES 2
Jeff_Perkinson
Community Manager Community Manager

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

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

-Jeff
chemguy
Level I

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

Thanks Jeff