BookmarkSubscribe
Choose Language Hide Translation Bar
Highlighted
chemguy
Community Trekker

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

0 Kudos
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

0 Kudos
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

View solution in original post

0 Kudos
chemguy
Community Trekker

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

Thanks Jeff

0 Kudos