BookmarkSubscribe
Choose Language Hide Translation Bar
TheSource
Community Trekker

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? 

0 Kudos
1 REPLY 1
Highlighted
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