For numeric columns, the Format menu appears in the Column Info window. Specify the format to tell JMP how to display numbers in the column. For all format options, you can specify the number of total characters that you want the cells in the column to accommodate. See Specify Width.
Tip: To add commas to values that equal a thousand or more, select the Use thousands separator option. You must account a space for each comma in the Width box, or else they might not appear. This option is available for the Best, Fixed Dec, Percent, and Currency formats.
–
|
If the number of integers following the decimal point is smaller than the number of decimal places that you specify, zeros are added to reach the number of decimal places. For example, if the value is 1.23 and you type 5 in the Dec box, JMP shows the number with five decimal places: 1.23000.
|
Formats values with two decimal positions, thousands separators, and the currency sign that is specified in your computer’s locale settings. The default width of the Currency format is 15. If you have a number that requires a wider field width, the format defaults to the Best format. Once assigned, the currency symbol appears in the column and in graphs that contain the column.
Shows all values in the column as a specific instance in time, such as 12/2/03 at 2:23 PM. See Time Formats.
–
|
:day:hr:m, :day:hr:m:s show a duration of time, such as 52:03:01:30, or fifty-two days, three hours, one minute, and thirty seconds.
|
–
|
hr:m, hr:m:s, min:s shows a duration of time, such as 17:37, or seventeen hours and thirty-seven minutes.
|
In each format, the last field can have a fraction part. You can specify the direction with either a signed degree field or a direction suffix. To show a signed degree field, such as -59°00'00", deselect Direction Indicator. To show the direction suffix, such as 59°00'00" S, select Direction Indicator.
To use spaces as field separators, deselect Field Punctuation. To use degrees, minutes, and seconds symbols, select Field Punctuation.
Enables you to define a custom format for a numeric column. Select Custom, click Set Custom Format, and define the format in the Formula Editor window. For example, if you don’t want to display the percentage sign next to a number, select this option and multiply the number by 100. This is an alternative to selecting the Percent format. Or if your data is in meters and you want to show it in kilometers with the unit, add the formula Char(:value / 1000) || " km". You might also want to apply a date/time format that isn’t available in the Format Date or Time lists, such as D/M/Y.
If you assign a date format to a numeric column that already contains data, then the numeric values are treated as the number of seconds since January 1, 1904. For example, if you have a numeric column with a cell value of 1,234,567,890 and you change the format to Date > m/d/y, the cell value appears as 02/13/1943.
The examples in Table 5.1 use the date of December 31, 2004.
Note: To change how a date appears in a graph without changing how it appears in a data table, see Change the Numeric Format of an Axis in JMP Reports.
–
|
–
|
–
|
•
|
:day:hr:m and :day:hr:m:s show the number of days, hours, minutes, and seconds since January 1, 1904. For example, the results for December 31, 2004 are :36890:00:10: and :36890:00:10:00.
|
•
|
h:m:s and h:m show the hours, minutes, and seconds portion of the date in the date field. For example, the results for December 31, 2004 at 12:10 AM are 12:10:00 AM and 12:10 AM.
|
•
|
yyyy-mm-ddThh:mm and yyyy-mm-ddThh:mm:ss show the year, month, day, and time. For example, 2004-12-31T12:10:00. T is a literal value, representing itself.
|
Note: To change how a time appears in a graph without changing how it appears in a data table, see Change the Numeric Format of an Axis in JMP Reports.
If you are importing or entering data that contains formatting specific to country standards, you might need to make sure that your number formats are interpreted correctly. On Windows, access the Control Panel’s region and language option, and select the country for which the number should be formatted. On the Macintosh, from the Apple menu, select System Preferences > Language & Text > Formats, and select the correct country. On later versions of Macintosh, this option may appear under System Preferences > Language and Region.