On 10/16/2006 11:58 AM, Lan Barnes wrote:
I'm using a spreadsheet to make data sheets for an open-book
certification exam I'm going to be taking. The need is speed of look up.
One of the tables I'm compiling is a list of ISO, IEEE, and European
standards documents by number with a 1-sentence blurb from the text. I
want the standards number field to sort as an alpha, i.e.:
91
900
sorts to
900
91
This facilitates look up.
Using Open Office Calc, I can't find out how to do this.
Qs:
1. Does Gnumeric do this?
2. Does OOC but I just don't know how?
I have the workaround of adding the same alpha to the front of each
numeric value, as in:
x91
x900
sorts to
x900
x91.
TIA,
Create another column (call it the "text column") and in each cell put a
formula which converts the value in the numeric column to an alpha
representation. Try =TEXT(A5;"#"). Then use the text column as the
sort key. Hide the text column after sorting if you like.
Karl
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
