Currency

The Currency field is a numerical field that stores monetary values. It has more options to configure the currency locale and the currency symbol that it shows.

Ask NocoAI

Copy a prompt, paste it into NocoAI in any base, and replace the words in [brackets] with your own.

Add a [Budget] field in [US dollars] to this table
Change [Amount] to a currency field in [euros]
What is the total of [Amount] in this table?

Create a Currency field

Click the + icon next to the last field in your table.
Enter a name for the field.
Select Currency from the list of field types.
Configure Currency Locale (default: en-US).
Configure Currency Symbol (default: $).
(Optional) To shorten long values in the cell, select a Large number abbreviation option. Refer to Large number abbreviation below.
(Optional) Set a default value for the field.
(Optional) Add a description.
Click Save Field. NocoDB adds the field to your table.

Refer to the general guidelines on creating a field.

Large number abbreviation

Use the Large number abbreviation dropdown to show long amounts in a short form, such as $1.23M instead of $1,234,567.89. The default is None. With None, amounts stay full length.

Option	Example (1234567.89 in `en-US`, USD)
None	`$1,234,567.89`
Auto	`$1.23M`
Thousand	`$1,234.57K`
Million	`$1.23M`
Billion	`$0B`
Trillion	`$0T`

Auto selects the unit from the size of the amount: K for thousands, M for millions, B for billions and T for trillions. Amounts below one thousand are not abbreviated. But, like shortened amounts, they drop trailing zeros. The other options always use the unit that you select. Thus an amount much smaller than that unit rounds down to 0.

Shortened amounts keep the currency symbol and locale formatting of the field. They show a maximum of two decimal places and drop trailing zeros. The unit stays attached to the number. Thus, in a locale that puts the symbol after the amount, the value shows as 1,23M €.

Large number abbreviation options on a Currency field

Abbreviation changes only how the amount is displayed. NocoDB stores the full value, and this setting does not change it. Thus sorting, filtering and formulas do not change. To see and edit the full amount, click into a cell. When you copy a cell, you copy the full amount, not the shortened text.

A field that shows shortened amounts also accepts them when you paste. If you paste 1.2M into a cell, NocoDB stores 1200000. You cannot type a suffix into a cell. If you do, the cell goes back to its stored value.

On a PostgreSQL money column, the dropdown and the other currency options are disabled. The column type has its own currency settings.


AED	AFN	ALL	AMD	ANG	AOA
ARS	AUD	AWG	AZN	BAM	BBD
BDT	BGN	BHD	BIF	BMD	BND
BOB	BOV	BRL	BSD	BTN	BWP
BYN	BYR	BZD	CAD	CDF	CHE
CHF	CHW	CLF	CLP	CNY	COP
COU	CRC	CUC	CUP	CVE	CYP
CZK	DJF	DKK	DOP	DZD	EEK
EGP	ERN	ETB	EUR	FJD	FKP
GBP	GEL	GHC	GHS	GIP	GMD
GNF	GTQ	GYD	HKD	HNL	HRK
HTG	HUF	IDR	ILS	INR	IQD
IRR	ISK	JMD	JOD	JPY	KES
KGS	KHR	KMF	KPW	KRW	KWD
KYD	KZT	LAK	LBP	LKR	LRD
LSL	LTL	LVL	LYD	MAD	MDL
MGA	MKD	MMK	MNT	MOP	MRO
MRU	MTL	MUR	MVR	MWK	MXN
MXV	MYR	MZN	NAD	NGN	NIO
NOK	NPR	NZD	OMR	PAB	PEN
PGK	PHP	PKR	PLN	PYG	QAR
ROL	RON	RSD	RUB	RWF	SAR
SBD	SCR	SDD	SDG	SEK	SGD
SHP	SIT	SKK	SLE	SLL	SOS
SRD	SSP	STD	STN	SVC	SYP
SZL	THB	TJS	TMM	TMT	TND
TOP	TRY	TTD	TWD	TZS	UAH
UGX	USD	USN	USS	UYI	UYU
UYW	UZS	VEB	VED	VES	VND
VUV	WST	XAF	XAG	XAU	XBA
XBB	XBC	XBD	XCD	XDR	XFO
XFU	XOF	XPD	XPF	XPT	XSU
XTS	XUA	XXX	YER	ZAR	ZMK
ZMW	ZWD	ZWG	ZWL

Good to know

Currency formatting applies only to the display. The stored value stays numerical for calculations and formulas.

Currency

Create a Currency field

Large number abbreviation

Cell display

Supported locales

Supported currencies

Good to know