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
TheSource
Level II

Chang default numeric format

I have a fixed workstream where I import an excel file into JMP12. This file consists of mixed data type columns. My issue is with the format of the numeric columns. By default, JMP formats the column as "best" which is anything but (e.g. 1e-9 is displayed as 0.000000001). Is there a way to change the default number format to engineering rather than best? 

1 REPLY 1
txnelson
Super User

Re: Chang default numeric format

I have not seen such an option, however, interactively, you can do a one step "Standardize Attributes"  or use the following script to make the changes:

Names Default To Here( 1 );
dt = Current Data Table();
colNames = dt << get column names( continuous, string );
For( i = 1, i <= N Items( colNames ), i++,
	Column( dt, colNames[i] ) << format( "scientific", 10, 3 )
);
Jim