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
and when pasted here the table was created automatically (later I deleted the extra column).