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 via the Decimals places option.

Representation. These values are represented in decimal format, with or without commas (e.g., 1000 or 1,000). Negative values of the variable can be represented either with a negative sign (e.g., -1000) or with parentheses enclosing the number (e.g., (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 (e.g., 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 will treat the value as a text label.

Date

Select this category in order for variables to be interpreted as dates (e.g., 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 will format the date display using the specifications given in the Regional Settings dialog 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 will display 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 (e.g., used to label scale values). Statistica will format the display of time values according to the current settings in the Regional Settings dialog 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 will use 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 via the Decimal places edit field.

Representation. The first representation (standard scientific notation) will display 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 will apply the scientific format only to those (small) values of the variable which would be displayed as 0 (zero) in Number format [i.e., 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 would be 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 via 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; e.g., $, DM, etc., see the Regional Settings dialog in the Control Panel). You can choose to represent negative values of the variable either with a negative sign (e.g., $-1,000) or with parentheses enclosing the number (e.g., ($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 via 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 (e.g., 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.