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