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.
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.
: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.
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, you might divide the value by 100.
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 Date Formats use the date of December 31, 2004.
: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.

Help created on 9/19/2017