# Number formats

Release: |
---|

Number format controls options such the number of decimal digits, the currency sign, commas to separate thousands, and display of negative numbers. It also controls the format of dates. You can set a format for numbers and dates displayed in an edit table, result table, graph, or field of a user input, or output. The number format of an index applies wherever that index is used, including row or column headers of a table, or graph axis that uses that index. With Analytica 5.0, you can set a number format for each cell, row, column, or other slice of an array.

You can enter a number into an expression or table in any format, no matter what output format it uses.

### Number format dialog

To set the number format for a variable:

- Select the variable to format by showing its edit table, result table, or graph, or by selecting its node in a diagram. You can apply the same format to multiple variables at once if you select their nodes together in a diagram.
- Select
**Number format**from the Result menu, or press*Control+b*, to show this dialog:

- Select the format type you want from the list on the left.
- Select options you want, such as
,**Decimal digits**,**Show trailing zeroes**, or**Thousands separators**, from the menus and checkboxes. The options available depend on which format you selected.**Show currency symbol** - View the example at the top of the dialog to see if the format is what you want.
- If so, click the
**Apply**button.

You can change the default number format by pressing **Set Default**. The default format applies to all variables in your model whose number format has not been explicitly set.

### Types of number format

The default number format is * suffix*, which uses a letter after the number to denote order of magnitude -- for example, 10K means 10,000, where

*K*means Kilo or thousands. Choose one of these number formats:

Format Description Example Suffix A letter after the number specifies power of ten 12.35K Exponential Scientific notation, where the number after 'e' gives the powers of ten

1.2345e04 General (new to Analytica 5.0) Floating point number with a specified number of significant digits. Reverts to scientific notation only when a number is extreme, or the non-scientific notation depiction would contain more than the specified number of significant digits. 12345.678 Fixed Point Number with a fixed number of digits after the decimal point 12345.68 Integer A whole number with no decimals shown 12346 Date Show number (days since 1 Jan 1900) as a date and/or time (see below for format options)

12 Jan 2007 Boolean Display 0 as , and any other number as`False`

`True`

True, False Hexadecimal (new to Analytica 5.0) Display an integer in base-16 using the digits 0-9 and a-f. The number is prefixed with `0x`

. When a negative number is displayed, its two's complement is shown.0x303a Binary (new to Analytica 5.0) Display an integer in base-2 using the digits 0 and 1. The number is prefixed with `0xb`

. When the number is negative, its 64-bit two's complement is shown.0b11000000111010

#### Suffix number format

Suffix is Analytica’s default number format. It uses a conventional letter after each number to specify powers of 10: 12K means 12,000 (* K *for kilo or thousands), 2.5M means 2,500,000 (

*for Mega or millions), 5n means 0.000,000,005 (*

**M***means nano or billionths). Here are the suffix characters:*

**n**Power of 10 Suffix Prefix Power of 10 Suffix Prefix 10 ^{-2}% percent 10 ^{3}K Kilo 10 ^{-3}m milli 10 ^{6}M Mega or Million 10 ^{-6}μ or u micro (mu) 10 ^{9}G or B Giga or Billion 10 ^{-9}n nano 10 ^{12}T Tera or Trillion 10 ^{-12}p pico 10 ^{15}Q Quadrillion 10 ^{-15}f femto

^{9}in integer or fixed point format, or larger than 10

^{18}in suffix format.

**Maximum precision**: The maximum number of digits including decimal digits is 15 (14 for fixed point and percent). The maximum precision is 15 digits (9 for integers).

## Number format options

**Decimal digits**: The number of digits to show after the decimal point.

**Show trailing zeroes**: Check to show trailing zeroes in decimals, e.g., 2.100 instead of 2.1, when decimal digits are set to 3.

**Thousands separators**: Check to show commas between every third digit of the integer part, e.g., 12,345.678, instead of 12345.678.

**Display dates as numbers**: Displays a date or time data type as a number, where the value is the number of days after the date origin.

**Display numbers as dates**: Interprets a numeric value as a date, equal to the number of days past the date origin.

**Show currency symbol**: Check to show a currency symbol. Select the symbol and placement from these menus.

Placement controls the relative location of the currency symbol, e.g., **$200 **or **200DM**, and whether to use a minus sign **-$200 **or parentheses **($200) **to indicate a negative number.

**Regional settings**: If you select the last entry, **regional**, from the **Symbol **or **Placement **menu, it uses, respectively, the regional currency or placement settings set for your computer. You can modify these settings in the **Regional and Language **options available from the Windows Control Panel.

## See Also

Enable comment auto-refresher