**Standard Formatting**

The clip below outlines how the standard formatting options work:

**123 (Numeral)** -** **Allows the number to de displayed without any notation

**% (Percent)** - Allows the number to be displayed as a percentage (Please note that the raw format of the number in the dataset must be a decimal. The number format then multiplies the decimal by 100 and displays the percent symbol.)

**$$ (Currency) -** Allows the number to be displayed in your local currency. (Uses the $ symbol in the formatting, but the output will be the local currency sign $, £, or €. Local Currency is based on account's language setting.)

**00011** - Allows the number to be displayed in computer notation (Please note that the raw format of the number must be in bytes. The number format then converts the number to the appropriate magnitude using binary calculation [1024 base].)

**Decimals**

All four options listed above, allow the option to display decimals. To configure the desired number of decimal places to display, simply hover of the box titled "Decimals:" and use the arrows that appear to select the desired number.

Please note by default all numbers are set to not display decimals, which rounds the number to the nearest whole.)

**Abbreviations**

The Numeral and Currency options listed above, provide two options to display the number:

-Regular: Which shows the full number using commas to separate the number places accordingly (ones, tens, hundreds, etc)

-Abbreviated: Rounds to the nearest thousandth and displays a letter for the magnitude change

**Custom Formatting**

To use our Custom formatting option, Select the "Custom" option from the number formatting modal.

**Formatting Options**

Field Value (raw format) |
Formatting |
Output |
Description |

Numerals |
|||

79880 | ###0 | 79880 | Rounds to nearest whole |

82345 | #,###.0 | 82,345.0 | One forced figure after the decimal point and separators in the whole number where appropriate |

28951245643 | #,###.#0 | 28,951,245,643.00 | Two forced factors after the decimal point and separators in the whole number where appropriate |

49 | #.###,#0 | 48.991562 | Five forced factors after the decimal point |

6155 | #,#.###0 | 6,154.7591 | Four forced factors after the decimal point and separators in the whole number where appropriate |

42345 | #,0 | 42,345 | Separators in the whole number where appropriate and round to nearest whole number |

824 | +#,0 | +824 | Round to nearest whole, separators where appropriate, and display positive or negative notations where appropriate |

1237 | #.##0 | 1236.889 | Three forced factors after the decimal point |

222 | #[.]####0 | 221.44589 | If appropriate, 5 factors after the decimal point (if no decimal, it shows as a whole number) |

225 | #[.]####0 | 225 | (same as above just noting difference) |

-2984 | (#,#.###0) | (2983.1490) | Four forced factors after the decimal point and separators in the whole number where appropriate. If the number is negative, it will appear in parenthesis. |

3234 | .#0 | .54 | Strips the whole number and displays only the decimals to two forced factors after the decimal |

23413 | #.####0 | 23412.97000 | Five forced factors after the decimal point and displays the whole number |

1965 | #.#[###0] | 1965.125 | Displays 1 forced factor after the decimal with allowance up to 5 total, if appropriate and displays the whole number |

254976 | #.0a | 255.0k | Rounds to the nearest thousandth with one factor after the decimal and displays a letter for the magnitude change |

127423 | 0 a | 127 k | Rounds to the nearest thousandth and displays a letter for the magnitude change, with a space between the magnitude symbol and the number |

896783 | 0a | 897k | Rounds to the nearest thousandth and displays a letter for the magnitude change |

156 | 0o | 156th | Adds ordinal leters after the number, rounds to the nearest whole number (1st, 2nd, 3rd, 4th...) |

Percentages |
|||

3 | ##.#0% | 300.00% | Multiplies the value by 100, adds a percent sign, and forces two factors after the decimal |

3.556 | #0% | 356% | Multiplies the value by 100, adds a percent sign, and rounds to the nearest whole number |

Computer Notations |
|||

28180294 | 0b | 27MB | Converts the number to bytes using binary calculation (1024 base). Rounds to the nearest whole number. |

4246 | 0 b | 4 KB | Converts the number to bytes using binary calculation (1024 base) with a space between the number and the unit. Rounds to the nearest whole number. |

5231 | #.0b | 5.2KB | Converts the number to bytes using binary calculation (1024 base). One forced factor after the decimal. |

23190 | #.##0 b | 23.190 KB | Converts the number to bytes using binary calculation (1024 base). Three forced factors after the decimal. |

Currency |
|||

(Use the $ symbol in the formatting, but the output will be the local currency sign $, £, or € ) (Local Currency is based on account language setting.) |
|||

231987 | $#,#.#0 | $231,1986.52 | Two forced factors after the decimal point, separators in the whole number where appropriate, and adds the local currency symbol at the beginning of the number |

6745 | #,#[.]#0 $ | 6,745.32 $ | If there are numbers after the decimal, there are two forced factors after the decimal point, separators in the whole number where appropriate, and adds a space and local currency symbol at the end of the number |

3459 | $ #,#[.]#0 | $ 3459.48 | If there are numbers after the decimal, there are two forced factors after the decimal point, separators in the whole number where appropriate, and adds a space and local currency symbol at the beginning of the number |

5222 | ($#,0) | $5,222 | Separators in the whole number where appropriate, round to nearest whole number, and adds local currency symbol at the beginning of the number. If the number is negative, it will show in parenthesis. |

9998 | $#.#0 | $9997.98 | Two forced factors after the decimal point and adds local currency symbol at the beginning of the number |

4246 | ($ #.#0 a) | $4.25 k | Displays the nearest thousandth with two factors after the decimal, displays a letter for the magnitude change, a space between the magnitude symbol and the number, and local currency symbol at the front of the number. If the number is negative, it will show in parenthesis. |

8232567 | $#.0a | $8.2m | Displays the nearest thousandth with one factor after the decimal, displays a letter for the magnitude change, and local currency symbol at the front of the number |

50675183678 | $0a | $51b | Rounds to the nearest thousandth, displays a letter for the magnitude change, and local currency symbol at the front of the number |

2657 | $ 0a | $ 3k | Rounds to the nearest thousandth, displays a letter for the magnitude change, and local currency symbol at the front of the number separated by a space |

## Comments

10 comments