topic Chang default numeric format in Discussions

Chang default numeric format

TheSource — Fri, 06 Sep 2019 23:45:12 GMT

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?

Re: Chang default numeric format

txnelson — Sat, 07 Sep 2019 00:04:55 GMT

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 )
);