How can text be added before a NatNum12-modified format code?

Setting the format code to the following doesn’t work:

"TOTAL IS "[NatNum12 upper cardinal]0

Expected: TOTAL IS ONE HUNDRED (if the cell has 100 as value)

(edit: by “doesn’t work” I mean that the format is not recognized, as evidenced in the preview window which goes blank, and no action is taken if applied)

Looks like no way. But you could put TOTAL IS to an adjacent cell to the left; or use a formula using TEXT.

Note that if it worked, the syntax would be

[NatNum12 upper cardinal]"TOTAL IS "0
1 Like

Created tdf#158555

1 Like

भारतीय नंबर सिस्टम के अनुसार लाख वाली संख्या के लिए उक्त फार्मेट का प्रयोग कैसे किया जा सकता है ।

Без малейшего понятия. Зато я точно знаю, что в этой Английской ветке следует писать по-английски.

2 Likes

It might help to write in English language here… translated:

According to the Indian number system, how can the above format be used for numbers having lakhs?

[NatNum12 ...] spellout is language dependent and seems not be implemented for Hindic. If you choose a Hindic (or other Indian locale) number format with group separator like #,##0.00 the grouping is applied as expected like 12,34,56,789.01 for the value 123456789.01.


The NatNum12 implementation uses libnumbertext by the https://numbertext.github.io/ folks, you might want to ask them to support Hindic and other Indian languages as well.

1 Like

Hallo

Workaround:

I another cell:

="TOTAL IS "& TEXT( A2 ;"[NatNum12 upper cardinal]0")
1 Like