Product Docs
Self Hosting
Scripts ☁
Changelog (EE)

Currency

This article explains how to create and use a Currency field.

The Currency field is a numerical field used to store monetary values. It provides additional options to configure the currency locale and symbol for display.

Currency formatting is applied only for display. The stored value remains numerical for calculations and formulas.

Create a Currency field

  1. Click the + icon next to the last field in your table.
  2. Enter a name for the field.
  3. Select Currency from the list of field types.
  4. Configure Currency Locale (defaults to en-US).
  5. Configure Currency Symbol (defaults to $).
  6. (Optional) Set a default value for the field and add a description.
  7. Click Save field to add the field to your table.

Refer to the general guidelines on creating a field.

Cell display

The Currency field appears as a numeric cell with the configured currency symbol and formatting.

Cell display

Supported locales

NocoDB supports locale codes based on the ISO639-1 standard.

Ensure the correct locale is selected to apply region-specific number formatting (e.g., en-US, fr-FR).

Supported currencies

The Currency field supports a wide range of ISO 4217 currency codes, including but not limited to:

AEDAFNALLAMDANGAOA
ARSAUDAWGAZNBAMBBD
BDTBGNBHDBIFBMDBND
BOBBOVBRLBSDBTNBWP
BYRBZDCADCDFCHECHF
CHWCLFCLPCNYCOPCOU
CRCCUPCVECYPCZKDJF
DKKDOPDZDEEKEGPERN
ETBEURFJDFKPGBPGEL
GHCGIPGMDGNFGTQGYD
HKDHNLHRKHTGHUFIDR
ILSINRIQDIRRISKJMD
JODJPYKESKGSKHRKMF
KPWKRWKWDKYDKZTLAK
LBPLKRLRDLSLLTLLVL
LYDMADMDLMGAMKDMMK
MNTMOPMROMTLMURMVR
MWKMXNMXVMYRMZNNAD
NGNNIONOKNPRNZDOMR
PABPENPGKPHPPKRPLN
PYGQARROLRONRSDRUB
RWFSARSBDSCRSDDSEK
SGDSHPSITSKKSLLSOS
SRDSTDSYPSZLTHBTJS
TMMTNDTOPTRYTTDTWD
TZSUAHUGXUSDUSNUSS
UYUUZSVEBVNDVUVWST
XAFXAGXAUXBAXBBXBC
XBDXCDXDRXFOXFUXOF
XPDXPFXPTXTSXXXYER
ZARZMKZWD

Number

This article explains how to create and use a Number field.

Decimal

This article explains how to create and use a Decimal field.