---
title: "Format Numeric Columns"
canonical: "https://support.appfire.com/space/TBL/74814909/Format%20Numeric%20Columns"
format: markdown
---
> Macro (div)
> 
> ### On this page
> 
> > Macro (toc)

# Overview

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. This functionality was introduced in [Version 6.2](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74814643) of the [Advanced Tables for Confluence](https://appfire.atlassian.net/wiki/spaces/TBL/overview) add-on.

[Version 6.4](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74814232) extended the support to provide the ability to **force the format** on the **view** of the data rows (**FF** and **M** formats). The actual data is not changed, just how it is displayed. This helps to keep the data looking consistent even if the provided data is not. The [Column Types](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74814401) parameter is used to specify what type of formatting is done. 

# Usage

The Formatting Options listed on this page can be defined through the [***Column Types***](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74814401)** **parameter within the following Macros:

- [CSV macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74815945)
- [Table Plus macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74815966)
- [Attachment Table macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74814506)
- [JSON Table Macro](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74815257)
- [SQL Macro](https://appfire.atlassian.net/wiki/spaces/SQL/pages/74320195)
- [SQL-query Macro](https://appfire.atlassian.net/wiki/spaces/SQL/pages/74320330)
- [SQL-file Macro](https://appfire.atlassian.net/wiki/spaces/SQL/pages/74318828)
- [Excel macro - 6.x](https://appfire.atlassian.net/wiki/spaces/XL/pages/76614039)

### Screenshot

![image](media://1859eb35-2bb4-4947-8475-74f30463e3e2)

# Formatting Options

> ℹ️ **Acknowledgement**
> ℹ️ 
> ℹ️ Advanced numeric formatting support is provided using javascript implemented by the [Table Library for Bob Swift Add-ons](https://appfire.atlassian.net/wiki/spaces/TBLSORT) with the help of the Numerals.js library (open source, MIT license). A summary of the relevant parts of the [numerals.js documentation](http://numeraljs.com/) is repeated here.

> Macro (table-plus)
> 
> ### 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 |

# Examples

The following example shows how numeric values can be converted in total rows:

- [Formatting the Auto Total Row for Numeric Columns](https://appfire.atlassian.net/wiki/spaces/TBL/pages/74815084)

# Internationalization

The format can be automatically switch to support various international differences by adding a **language** parameter to the format.

> ✅ A list of the languages available and their specification is available [here](https://github.com/adamwdraper/Numeral-js/tree/master/locales).

 For example:

> Macro (table-plus)
> 
> | **ColumnType** | **Value** | **Formatted Value** |
> | --- | --- | --- |
> | FF"(de)0,0.00 $" | 1.234,5 | 1 234,50 <span style="color: #000000">€</span> |
> | FF"(fr)$0,0.00" | 1 234,5 | <span style="color: #000000">€</span>1 234,50 |