On Thu, Oct 19, 2006 at 06:20:29PM -0700, David Looney wrote:
> Andrew Lentvorski wrote:
> > Ralph Shumaker wrote:
> >
> >> Then just run the macro as many times as you need to convert all your
> >> numbers to text.
> >
> > Is there a reason why you just can't create another column and use the
> > TEXT() function to convert from a number to a string?
>
> That approach certainly works (make new column A, and assuming values in
> B use A1 =TEXT(B:1;"#") and then sort on the new column). Unfortunately,
> however, this thread has already officially been declared dead by the
> originator, so this must just be morbid curiosity.
>
> David Looney
>
Well, yes and no. As the OP, I did discover, with everyone's help, that
if a column is marked as cells and defined as text _before_ any data
entry, then it sorts nicely. However in my experiments, if this is done
_after_ numeric data entry, it's too late for the whole column.
So functions like this aren't useless, because someone might want this
kind of sort after much data entry.
So sometimes the thread is dead; sometimes my interest is dead;
sometimes I am dead.
> --
> When we know we're being watched, our lives are altered, even if we're
> doing nothing wrong. - Bruce Schneier
>
snarfed. Who is Bruce Schneier? (Save me a google or wikipedia, which
I'm growing very fond of)
--
Lan Barnes
Linux Guy, SCM Specialist
Tcl/Tk Enthusiast
If you can't laugh at death, you really have no right to be here.
- Robert Altman
--
[email protected]
http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
