NatNum12 with and without decimals

Hello all,

Frequently I need to copy a range of numbers from Calc and paste it in Writer (one column, up to 16 rows, values between 6.00 and 10.00).

Then I modify, partly pasting from a 6 (six), 6.50 (six and 50/100), etc. list, and partly key after key when cents are not 50.

This question and answers opened my eyes a bit, so I were testing with NatNum12.

Could it be there a simpler formula than this one?
B2: =TEXT(A2;"0.00")&" ("&TEXT( A2 ;"[NatNum12 cardinal]0")&IF(MOD(A2;1)=0;")";" con "&ROUND((A2-ROUND(A2))*100)&"/100)")
NatNum with without decimals.ods (14.4 KB)

Source Target (pasted as unformatted text in Writer)
8 8.00 (ocho)
8.45 8.45 (ocho con 45/100)

Thanks all in advance.

Version: 7.5.9.2 (x86) / LibreOffice Community
Build ID: cdeefe45c17511d326101eed8008ac4092f278a9
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Raster; VCL: win
Locale: es-MX (es_MX); UI: en-US
Calc: threaded


By the way, I selected in Calc as
imagen
and when pasted here the table was created automatically (later I deleted the extra column).

not really, but:

=TEXT(A2;"0.00")&" ("&TEXT( A2 ;"[NatNum12 cardinal]0")&IF(MOD(A2;1)=0;")";" con "&TEXT(MOD(A2;1);"??/100)"))
1 Like

Great!
That is Fraction Representation. Every day learning more.
Thanks.

&TEXT(MOD(A24;1);"00/100)")

imagen
NatNum with without decimals.ods (22.1 KB)

&TEXT(TRUNC(A2);"[NatNum12 cardinal]0")
imagen
NatNum with without decimals.ods (12.2 KB)