Amount in words

How to use it

• Type the amount in digits: spaces, a comma or a point are fine (for example, 1,111,252.33).
• Use a space for thousands and a comma for the fraction; an ambiguous entry such as “1,234” is not accepted and an explanation appears.
• Tiyin are rounded to 2 decimals; if you like, tiyin can also be given in words.
• The result appears in four versions: Uzbek in Latin and Cyrillic, Russian and English. The “Copy” button moves the text into your document.
• The whole part can be up to 999,999,999,999,999 soums.

Examples

Examples made up by the author:

A ready Excel file and the formula

In the ready Excel file, type the amount in cell B3 and choose the script in B4 (1 — Latin, 2 — Cyrillic); the result appears in cell B6. The formulas are open and the words are on the “Lugat” sheet, where you can change them.

The calculation takes three steps: the amount is converted to tiyin; that is turned into a 17-digit text and cut into groups of three digits (trillion, billion, million, thousand, units); each group is written out with words for hundreds, tens and units. The main formulas:

B7:  =ROUND(B3*100,0)
B8:  =TEXT(B7,"00000000000000000")
B10: =VALUE(MID($B$8,1,3))
C10: =IF(B10=0,"",TRIM(IF(INT(B10/100)>0,INDEX(Lugat!$B$2:$C$11,INT(B10/100)+1,$B$4)&" "&INDEX(Lugat!$H$2:$I$2,1,$B$4),"")&" "&INDEX(Lugat!$D$2:$E$11,INT(MOD(B10,100)/10)+1,$B$4)&" "&INDEX(Lugat!$B$2:$C$11,MOD(B10,10)+1,$B$4)&" "&INDEX(Lugat!$H$6:$I$6,1,$B$4)))

Limits and note

• Cell B6 joins the groups (C10:C14), capitalises the first letter and adds the words for soum and tiyin at the end. Depending on your regional settings, Excel may need a semicolon instead of a comma.
• The Excel file works up to 9,999,999,999,999.99 soums: Excel calculates with 15-digit accuracy. The calculator on the site works up to 999,999,999,999,999 soums.
• In the Russian and English text the currency word (сум, сума, сумов; soum, soums) follows general grammar rules; if your organisation's document form requires a different wording, follow it.
• Official requirements for writing amounts in words in documents were not reviewed on this page.