On 2018-07-30 03:46 PM, Alvin Starr via talk wrote:
> Does anybody know how to display and work with SI numbers like 10k or
> 20M or 40G within LIbreOffice?
I had a think about this, and came up with this function for text in
cell D2:
=IF(LEN(T(D2))=0, D2,CONVERT(VALUE(LEFT(D2,
Not without macros. LibreOffice is kinda hamstrung by its file format and
MS Excel compatibility. Gnumeric can do this, but it's never had to play to
a big compatibility or business market.
It's supposed to have true engineering notation in LibreOffice Calc > 4.5
or so, not just the three s.f.
On 30 July 2018 at 15:46, Alvin Starr via talk wrote:
> Does anybody know how to display and work with SI numbers like 10k or 20M or
> 40G within LIbreOffice?
I think you may have to do it manually with a series of nested IF
statements. So, if x>1,000,000,000 then x/1,000,000,000 + "G" else if
On 07/30/2018 04:09 PM, Myles Braithwaite via talk wrote:
Alvin Starr via talk wrote on 2018-07-30 3:46 PM:
Does anybody know how to display and work with SI numbers like 10k or
20M or 40G within LIbreOffice?
I have had little luck searching with google et al.
While I am at it how about
Alvin Starr via talk wrote on 2018-07-30 3:46 PM:
Does anybody know how to display and work with SI numbers like 10k or
20M or 40G within LIbreOffice?
I have had little luck searching with google et al.
While I am at it how about engineering notation?
I think you looking for superscript
Does anybody know how to display and work with SI numbers like 10k or
20M or 40G within LIbreOffice?
I have had little luck searching with google et al.
While I am at it how about engineering notation?
--
Alvin Starr || land: (905)513-7688
Netvel Inc. ||