---
title: "How to change the format of numeric columns - Cloud"
canonical: "https://support.appfire.com/space/TBL/74814193/How%20to%20change%20the%20format%20of%20numeric%20columns%20-%20Cloud"
format: markdown
---
> Macro (aura-html)

# <span style="color: #000000">Overview</span>

<span style="color: #000000">Numeric values within total rows (of numeric table columns) can be formatted to look like currency, percentages, times, or plain numbers with decimal places, thousands, and abbreviations. </span><span style="color: #000000">The</span><span style="color: #000000"> app provides the ability to change the format of data using </span><span style="color: #000000">*FF*</span><span style="color: #000000"> and </span><span style="color: #000000">*M*</span><span style="color: #000000"> column types, without changing the actual data itself. This helps to keep the format consistent even if the format of the provided data is not. The </span><span style="color: #000000">*[Column types](https://appfire.atlassian.net/wiki/x/EZN1B)*</span><span style="color: #000000"> parameter is used to specify what type of formatting is done. </span>

# <span style="color: #000000">Usage</span>

<span style="color: #000000">The formatting options listed on this page can be defined through the</span> <span style="color: #000000">*Column types*</span>* *<span style="color: #000000">parameter within the following macros:</span>

- [Table Plus macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74812542)
- [CSV (Comma Separated Values) macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74812384)
- [JSON Table Macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74812316)
- [Attachment Table macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74812217)
- [SQL macro](https://appfire.atlassian.net/wiki/spaces/SQL/pages/172458339)
- [SQL File macro](https://appfire.atlassian.net/wiki/spaces/SQL/pages/172458378)
- [SQL Query macro](https://appfire.atlassian.net/wiki/spaces/SQL/pages/172458423)
- [Excel macro](https://appfire.atlassian.net/wiki/spaces/XL/pages/76613631)

## <span style="color: #000000">Screenshot</span>

![Advanced Tables numeric column formatting settings](media://ed96a95b-0db9-46b9-af06-c63dc7c30092)

# <span style="color: #000000">Formatting options</span>

> ℹ️ ### Acknowledgement
> ℹ️ 
> ℹ️ <span style="color: #000000">Advanced numeric formatting support is provided using Javascript with the help of the Numerals.js library (open source, MIT license). A summary of the relevant parts of the</span> [Numerals.js documentation](http://numeraljs.com/)<span style="color: #000000"> is repeated here.</span>

## Numbers

| **Value (Original)** | **Format definition** | **Value (Formatted)** |
| --- | --- | --- |
| 10000 | '0,0.0000' | 10,000.0000 |
| 10000.23 | '0,0' | 10,000 |
| 10000.23 | '+0,0' | +10,000 |
| -10000 | '0,0.0' | -10,000.0 |
| 10000.1234 | '0.000' | 10000.123 |
| 10000.1234 | '0[.]00000' | 10000.12340 |
| -10000 | '(0,0.0000)' | (10,000.0000) |
| -0.23 | '.00' | -.23 |
| -0.23 | '(.00)' | (.23) |
| 0.23 | '0.00000' | 0.23000 |
| 0.23 | '0.0[0000]' | 0.23 |
| 1230974 | '0.0a' | 1.2m |
| 1460 | '0 a' | 1 k |
| -104000 | '0a' | -104k |
| 1 | '0o' | 1st |
| 52 | '0o' | 52nd |
| 23 | '0o' | 23rd |
| 100 | '0o' | 100th |

## Currency

| **Value (Original)** | **Format definition** | **Value (Formatted)** |
| --- | --- | --- |
| 1000.234 | '$0,0.00' | $1,000.23 |
| 1000.2 | '0,0[.]00 $' | 1,000.20 $ |
| 1001 | '$ 0,0[.]00' | $ 1,001 |
| -1000.234 | '($0,0)' | ($1,000) |
| -1000.234 | '$0.00' | -$1000.23 |
| 1230974 | '($ 0.00 a)' | $ 1.23 m |

## Bytes

| **Value (Original)** | **Format definition** | **Value (Formatted)** |
| --- | --- | --- |
| 100 | '0b' | 100B |
| 2048 | '0 b' | 2 KB |
| 7884486213 | '0.0b' | 7.3GB |
| 3467479682787 | '0.000 b' | 3.154 TB |

## Percentages

| **Value (Original)** | **Format definition** | **Value (Formatted)** |
| --- | --- | --- |
| 1 | '0%' | 100% |
| 0.974878234 | '0.000%' | 97.488% |
| -0.43 | '0 %' | -43 % |
| 0.43 | '(0.000 %)' | 43.000 % |

## Time

| **Value (Original)** | **Format definition** | **Value (Formatted)** |
| --- | --- | --- |
| 25 | '00:00:00' | 0:00:25 |
| 238 | '00:00:00' | 0:03:58 |
| 63846 | '00:00:00' | 17:44:06 |

# <span style="color: #000000">Examples</span>

<span style="color: #000000">The following example shows how numeric values can be formatted in total rows:</span>

- [Formatting the auto total row for numeric columns](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74815084)

# <span style="color: #000000">Internationalization</span>

<span style="color: #000000">The format can be automatically switch to support various international differences by adding a </span><span style="color: #000000">*language*</span><span style="color: #000000"> parameter to the format.</span>

> ✅ <span style="color: #000000">A list of the languages available and their specification is available</span> [here](https://github.com/adamwdraper/Numeral-js/tree/master/locales)<span style="color: #000000">.</span>

##  <span style="color: #000000">Example</span>

| **Column type** | **Value** | **Formatted value** |
| --- | --- | --- |
| FF"(de)0,0.00 $" | 1.234,5 | 1 234,50 € |
| FF"(fr)$0,0.00" | 1 234,5 | €1 234,50 |