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 -- When we know we're being watched, our lives are altered, even if we're doing nothing wrong. - Bruce Schneier -- [email protected] http://www.kernel-panic.org/cgi-bin/mailman/listinfo/kplug-list
