Cell formatting

From: frank brierley <frank_n_brierley yahoo com au>
To: Gnumeric List <gnumeric-list gnome org>
Subject: Cell formatting
Date: Fri, 30 Jan 2004 16:17:56 +1000

Hi,

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
or
654,380,000 => 654.4E6

Frank

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