Cell formatting


Regarding cell formatting.

Gnumeric has the option to format a cell with the code ##0.0E0.  This
result in...

10,000 => 1.0E4

Considering engineering units, kilo, Mega, Giga, etc. or, in other
words, sets of three orders of magnitude.  So 10,000 metres becomes 10
kilometres.  Is there a way to convince Gnumeric to format a number in a
cell in this fashion?

10,000 => 10.0E3
654,380,000 => 654.4E6


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]