Spreadsheet Display Formats

With Statistica Spreadsheets, you can choose a display format to accompany a variable with a double, integer, or byte data type.

See also, Spreadsheet Data Types.

Display Format Explanation
General This category has no specific number format.
Number Select this category if the values of the variable are numeric, or numeric with text equivalents.

When you select this category, you can specify the number of decimal places to be displayed in the spreadsheet using the Decimals places option.

Representation: These values are represented in decimal format, with or without commas (such as1000 or 1,000).

Negative values of the variable can be represented either with a negative sign (example, -1000) or with parentheses enclosing the number (such as, (1000)). There are four Number representations available in this category:

1000;-1000

1,000;-1,000

1000;(1000)

1,000;(1,000)

Note that a European representation (such as, 1,20) is supported by Statistica if you select this style in the Control Panel. If this style is not selected in the Control Panel, and you enter a comma in the decimal place, Statistica treats the value as a text label.

Date Select this category in order for variables to be interpreted as dates (such as  variables containing Julian date values imported or pasted from Excel). Note that in order to be displayed as a valid date, all values in the variable must be correct dates or explicitly defined text labels.

Representation: Select the desired Date representation from the list of Date formats. In the Edit Format dialog box, the various Date representations are as follows:

  • 3/17/92
  • 03/17/1992
  • 17-Mar-92
  • 17-Mar
  • Mar-1992
  • 17/03/92
  • 1992/03/17

Windows Date Format: Note that if the Windows Date Format is selected, Statistica formats the date display using the specifications given in the Regional Settings dialog box of the Control Panel.

Conversion of Julian days to displayed dates: The exact algorithm of how integer values (Julian date or days) are converted to standard dates and vice versa is affected by the setting of the Adjust Julian dates to account for no leap year in 1900 option on the Options dialog box - Spreadsheet tab.

 For example, a date entered and displayed as 1/21/1968 may be stored as the Julian date 24858 or 24856, depending on the setting of that option.

Time This category displays the values of the variables in one of several Time formats.

Time values of variables are stored in the data as (optional) decimal values representing the fraction of the day since midnight. For example, 6:00AM is stored as 0.25. Time values stored in this manner can be used in subsequent analyses and transformed using arithmetic operations; at the same time, they can be displayed as times in reports or graphs (for example, used to label scale values). Statistica formats the display of time values according to the current settings in the Regional Settings dialog box of the Control Panel.

Representation: Time can be represented in one of several formats. You can choose from a date-time combination [with either 24-hour time or 12-hour (AM/PM) time format], or just time [either a 24-hour time or 12-hour (AM/PM) time format] in hours and minutes or hours, minutes, and seconds. You could also select the Windows Time Format, which uses the current settings in the Regional Settings dialog box of the Control Panel. In the Edit Format dialog box, the various Time representations are as follows:
  • 3/17/92 5:20 PM
  • 3/17/92 17:20
  • 5:20 PM
  • 17:20
  • 5:20:19PM
  • 17:20:19
  • Windows Time Format
Scientific This category allows you to display the values of the variable in scientific notation.

 When you select this category, you can specify the number of decimal places to be displayed in the spreadsheet using the Decimal places edit field.

Representation: The first representation (standard scientific notation) is displayed all numbers in the column in scientific notation according to the following rules:

For example, 1.2345E-02 or -3.2100E+08.

The second representation applies the scientific format only to those (small) values of the variable which are displayed as 0 (zero) in Number format [that is, they are from the interval (-1,1) and the significant digits start after the position specified by the Decimal places edit field]. For example, if Decimal places = 4, and the value is 0.0000123, then in Number format, the value would be displayed as 0.0000, whereas, in the second Scientific representation, the number is displayed as 1.230E-5 (displaying 4 digits before E).

Currency Select this category to display the values of the variable in a Currency format.

When you select this category, you can specify the number of decimal places to be displayed in the spreadsheet using the Decimal places edit field.

Representation: Currency values are displayed with a currency symbol before or after the number (depending on the configuration specified on your computer; example, $, DM, see the Regional Settings dialog box in the Control Panel). You can choose to represent negative values of the variable either with a negative sign (example, $-1,000) or with parentheses enclosing the number (example, ($1,000)). In the Edit Format dialog box, the Currency representations are as follows:

$1,000; -$1,000

$1,000; ($1,000)

Percentage Select this category to display the values of the variable as percentages.

When you select this category, you can specify the number of decimal places to be displayed in the spreadsheet by the Decimal places edit field. The percentage is based on what fraction of 1 the value of the variable represents. For example, the value 0.23 will be translated to 23% while 23.4 will be translated to 2340%.

Representation: Percentages are represented with a % character at the end of the number.

Fraction Select this category to display the values of the variable as fractions. When you select this format, you can choose the number of digits (one or two) to be displayed in the fraction, or the denominator to be used in the fraction (example, sixteenth).

Representation:

In the Edit Format dialog box, the Fraction representations are as follows:
  • Up to one digit (1/2)
  • Up to two digits (17/29)

    Up to three digits (129/257)

  • As halves (1/2)
  • As fourths (1/4)
  • As eighths (5/8)
  • As sixteenths (3/16)
  • As thirty-seconds (17/32)
  • As tenths (7/10)
  • As hundredths (77/100)
Custom This category of display formats allows you to choose from predefined Custom number formats, or to create your own using standard custom number format syntax.

The sections of the custom number format are separated by colons. The section before the semicolon defines how a positive number is displayed. The section after the semicolon defines how a negative number is displayed.

See custom number format codes for more information about the syntax used to create new custom number display formats.