Reference: Measurement Units in Worksheets Functions
These tables list the primary units of measurement that Worksheets functions support. Use the
abbreviations in formulas.
For more information, see the Java library
javax.measure.unit.Dimension
.Abbreviations are case-sensitive.
Make sure that all unit types in a formula are compatible. Example: Don't try to convert a
distance unit to a time unit.
Weight and Mass
Abbreviation | Name |
|---|---|
g | Gram |
u | U (Atomic Mass Unit) |
grain | Grain |
uk_cwt | Imperial hundredweight |
lcwt | Imperial hundredweight |
hweight | Imperial hundredweight |
stone | Stone |
ton | Ton |
uk_ton | Imperial ton |
LTON | Imperial ton |
brton | Imperial ton |
Distance
Abbreviation | Name |
|---|---|
m | Meter |
mi | Statute mile |
Nmi | Nautical mile |
in | Inch |
ft | Foot |
yd | Yard |
ang | Angstrom |
ly | Light year |
Picapt | Picapt (point: 1/72 inch) |
Pica | Pica (1/72 inch) |
pica | pica (1/6 inch) |
survey_mi | US survey mile (statute mile) |
Time
Abbreviation | Name |
|---|---|
yr | Year |
day | Day |
d | Day |
hr | Hour |
mn | Minute |
min | Minute |
sec | Second |
s | Second |
Energy
Abbreviation | Name |
|---|---|
J | Joule |
c | Thermodynamic calorie |
cal | IT calorie |
eV | Electron volt |
HPh | Horsepower-hour |
hh | Horsepower-hour |
Temperature
Abbreviation | Name |
|---|---|
C | Degree Celsius |
cel | Degree Celsius |
F | Degree Fahrenheit |
fah | Degree Fahrenheit |
K | Kelvin |
kel | Kelvin |
Volume (Liquid Measure)
Abbreviation | Name |
|---|---|
tsp | Teaspoon |
tbs | Tablespoon |
oz | Ounce |
cup | Cup |
pt | Pint |
us_pt | US pint |
uk_pt | UK pint |
qt | Quart |
uk_qt | Imperial quart |
gal | Gallon |
uk_gal | Imperial gallon |
l | Liter |
L | Liter |
lt | Liter |
barrel | US oil barrel |
bushel | US bushel |
ft^3 | Cubic feet |
in^3 | Cubic inch |
m^3 | Cubic meter |
mi^3 | Cubic mile |
yd^3 | Cubic yard |
Pica^3 | Cubic Pica |
MTON | Measurement ton (freight ton) |
Area
Abbreviation | Name |
|---|---|
uk_acre | International acre |
us_acre | US survey/statute acre |
ang^2 | Square angstrom |
ft^2 | Square feet |
in^2 | Square inches |
m^2 | Square meters |
mi^2 | Square miles |
Picapt^2 | Square Pica |
Pica^2 | Square Pica |
yd^2 | Square yards |
Information
Abbreviation | Name |
|---|---|
bit | Bit |
byte | Byte |
Speed
Abbreviation | Name |
|---|---|
m/h | Meters per hour |
m/hr | Meters per hour |
m/s | Meters per second |
m/sec | Meters per second |
mph | Miles per hour |
Persons
Abbreviation | Name |
|---|---|
person | Person |
pers | Person |
emp | Employee |
hc | Headcount |
head | Head |
Currency
Abbreviation | Name |
|---|---|
AFA | Afghani |
AFN | Afghani |
ALK | Albanian Old Lek |
DZD | Algerian Dinar |
ADF | Andorran Franc |
ADP | Andorran Peseta |
AOR | Angolan Kwanza Readjustado |
ARS | Argentine Peso |
AMD | Armenian Dram |
AWG | Aruban Florin |
AUD | Australian Dollar |
ATS | Austrian Schilling |
AZM | Azerbaijani Manat |
AZN | Azerbaijanian Manat |
BSD | Bahamian Dollar |
BHD | Bahraini Dinar |
THB | Baht |
PAB | Balboa |
BBD | Barbados Dollar |
BYR | Belarussian Ruble |
BEF | Belgian Franc |
BZD | Belize Dollar |
BMD | Bermudian Dollar |
VEF | Bolivar |
BOB | Boliviano |
BRL | Brazilian Real |
BND | Brunei Dollar |
BGN | Bulgarian Lev |
BIF | Burundi Franc |
CVE | Cabo Verde Escudo |
CAD | Canadian Dollar |
KYD | Cayman Islands Dollar |
XOF | CFA Franc BCEAO |
XAF | CFA Franc BEAC |
XPF | CFP Franc |
CLP | Chilean Peso |
COP | Colombian Peso |
KMF | Comoro Franc |
CDF | Congolese Franc |
BAM | Convertible Mark |
NIO | Cordoba Oro |
CRC | Costa Rican Colon |
HRK | Croatian Kuna |
CUP | Cuban Peso |
CYP | Cyprus Pound |
CZK | Czech Koruna |
GMD | Dalasi |
DKK | Danish Krone |
MKD | Denar |
DJF | Djibouti Franc |
STD | Dobra |
DOP | Dominican Peso |
VND | Dong |
NLG | Dutch Guilder |
XCD | East Caribbean Dollar |
ECS | Ecuador Sucre |
ECV | Ecuador Unidad de Valor Constante |
TJR | Tajikistani ruble |
EGP | Egyptian Pound |
SVC | El Salvador Colon |
ETB | Ethiopian Birr |
EUR | Euro |
XEU | European Currency Unit |
FKP | Falkland Islands Pound |
FJD | Fiji Dollar |
FIM | Finnish Markka |
HUF | Forint |
FRF | French Franc |
DEM | German Mark |
GHC | Ghana Cedi |
GHS | Ghana Cedi |
GIP | Gibraltar Pound |
XFO | Gold Franc |
HTG | Gourde |
GRD | Greek Drachma |
PYG | Guarani |
GNF | Guinea Franc |
GWP | Guinea-Bissau Peso |
GYD | Guyana Dollar |
HKD | Hong Kong Dollar |
UAH | Hryvnia |
ISK | Iceland Krona |
INR | Indian Rupee |
IRR | Iranian Rial |
IQD | Iraqi Dinar |
IEP | Irish Pound |
ITL | Italian Lira |
JMD | Jamaican Dollar |
JOD | Jordanian Dinar |
KES | Kenyan Shilling |
PGK | Kina |
LAK | Kip |
EEK | Kroon |
KWD | Kuwaiti Dinar |
MWK | Kwacha |
AOA | Kwanza |
MMK | Kyat |
GEL | Lari |
LVL | Latvian Lats |
LBP | Lebanese Pound |
ALL | Lek |
HNL | Lempira |
SLL | Leone |
LRD | Liberian Dollar |
LYD | Libyan Dinar |
SZL | Lilangeni |
LTL | Lithuanian Litas |
LSL | Loti |
LUF | Luxembourgian Franc |
MGA | Malagasy Ariary |
MGF | Malagasy Franc |
MYR | Malaysian Ringgit |
MTL | Maltese Lira |
TMM | Manat |
MUR | Mauritius Rupee |
MXN | Mexican Peso |
MXV | Mexican Unidad de Inversion (UDI) |
MDL | Moldovan Leu |
MCF | Monegasque Franc |
MAD | Moroccan Dirham |
MZM | Mozambique Metical |
MZN | Mozambique Metical |
BOV | Mvdol |
NGN | Naira |
ERN | Nakfa |
NAD | Namibia Dollar |
NPR | Nepalese Rupee |
ANG | Netherlands Antillean Guilder |
ILS | New Israeli Sheqel |
RON | New Romanian Leu |
TWD | New Taiwan Dollar |
NZD | New Zealand Dollar |
BTN | Ngultrum |
KPW | North Korean Won |
NOK | Norwegian Krone |
PEN | Nuevo Sol |
OMR | Omani Rial |
MRO | Ouguiya |
TOP | Pa'anga |
PKR | Pakistan Rupee |
MOP | Pataca |
UYU | Peso Uruguayo |
PHP | Philippine Peso |
PTE | Portugese Escudo |
GBP | Pound Sterling |
BWP | Pula |
QAR | Qatari Rial |
GTQ | Quetzal |
ZAR | Rand |
KHR | Riel |
ROL | Romanian Leu |
MVR | Rufiyaa |
IDR | Rupiah |
RUB | Russian Ruble |
RWF | Rwanda Franc |
SHP | Saint Helena Pound |
SML | San Marinese Lira |
SAR | Saudi Riyal |
CSD | Serbian Dinar |
RSD | Serbian Dinar |
SCR | Seychelles Rupee |
SGD | Singapore Dollar |
SKK | Slovak Koruna |
SIT | Slovenian Tolar |
SBD | Solomon Islands Dollar |
KGS | Som |
SOS | Somali Shilling |
TJS | Somoni |
SSP | South Sudanese Pound |
ESP | Spanish Peseta |
LKR | Sri Lanka Rupee |
SDD | Sudanese Dinar |
SDG | Sudanese Pound |
SRD | Surinam Dollar |
SRG | Suriname Guilder |
SEK | Swedish Krona |
CHF | Swiss Franc |
SYP | Syrian Pound |
BDT | Taka |
WST | Tala |
TZS | Tanzanian Shilling |
KZT | Tenge |
TTD | Trinidad and Tobago Dollar |
MNT | Tugrik |
TND | Tunisian Dinar |
TRL | Turkish Lira |
TRY | Turkish Lira |
TMT | Turkmenistan New Manat |
AED | UAE Dirham |
UGX | Uganda Shilling |
COU | Unidad de Valor Real |
CLF | Unidades de fomento |
UYI | Uruguay Peso en Unidades Indexadas |
USD | US Dollar |
UZS | Uzbekistan Sum |
VAL | Vatican Coins |
VUV | Vatu |
VEB | Venezuelan Bolívar |
CHE | WIR Euro |
CHW | WIR Franc |
KRW | Won |
YER | Yemeni Rial |
JPY | Yen |
CNY | Yuan Renminbi |
YUM | Yugoslav Dinar |
ZMK | Zambian Kwacha |
ZMW | Zambian Kwacha |
ZWD | Zimbabwe Dollar |
ZWL | Zimbabwe Dollar |