Hello,

Zoho Sheets is a bad currency format for the Czech Republic. In principle, this is a critical mistake .

Thousands are separated either by space or dot. 1 000 Kč. # ##0,00 Kč;-# ##0,00 Kč

Separation (farthing) is only separated by commas "," 1 000,00 Kč.

The most erroneous area is digits. While in Czech the comma separates decimal places (eg 12,869 is twelve whole eight hundred sixty-nine), the comma separates thousands in English (12,869 will be twelve thousand eight hundred sixty-nine). The decimal places are then separated by a dot. We correctly use a non-breaking space for separating thousands, so-called non-breaking space (correctly 12,869, not 12,869, or 12869). However, be careful - some scientific publications in the English language do not use the comma separator rule and separate them as in Czech space. As an exception, natural sciences are mentioned where thousands are always separated by commas.

Serial numbers, such as centuries, are also a common mistake. In Czech, we write a period (21st century), but in English the format for ordinals (21st century or 21st century) is used. For example, Burton recalled that 16. Century was a difficult period would be considered a sentence two, and the reader would be perfectly confused

(Google translate) http://prirucka.ujc.cas.cz/?id=786

The currency symbol may be given after the monetary amount or and before her. The number and mark are separated by a space: CZK 100 = one hundred Czech crowns, CZK 2,000,000 = two million Czech crowns (see Signs, numbers and numbers). If there is no space between the number and the space mark, we read the compound expression as an adjective: 100Kc = 100Kc (see Creating and Writing Numbers and Words (12 Percent, 20 Times)).

We write the amounts and currency marks on the same line, separating the triple numbers with a space (see Line Breaks and Inappropriate Expressions at the End). Groups of three digits can be separated in administrative text instead of space by dot, eg the price of land is CZK 2,000,000 (CZK 2,000,000 can also be paid), fees increased by CZK 1,885.50 (CZK 1.805.50).

In the normal text, for decimal numbers, the dash is superfluous and inappropriate. Instead of CZK 500, - or 500, - CZK we recommend writing 500 CZK.

If the decimal values ​​(eg pennies) are included in the reports, then zeroes are written after the whole amounts to equal the number of decimal places for the individual amounts: CZK 500.00.

The currency units in the text are either worded, for example, we charge 500 Czech crowns, euros (the word euro is declined regularly according to the pattern “city”), dollars, pounds, yen, or we use currency signs, namely letters: CZK (= Czech crown ), zł (= zloty), Ft (= forint) or marks from letters of differently adjusted: € (= euro), $ (= dollar), £ (= pound), ¥ (= only) etc. , PLN, HUF, EUR, USD, GBP, JPY etc.) are usually used only in banking practice and in foreign correspondence.

In the text, currency signs are usually used in conjunction with a specific numerical value, and after numerals we read tags in the form of a 2nd fall or we apply a match according to the last member of the numeral, for example, we charge you $ 2,583 (two thousand five hundred eighty-three Czech crowns or two thousand five hundred eighty-three Czech crowns) - see chap. Number division, multi-word numeric expressions (type 365, 2,582) and decimal numbers and Numbered object by numerals.