Sorting or filtering numbers


Posted by Krissi on December 14, 2000 2:32 PM

I have a large spreadsheet with the following data in one column, and I need to sort or filter for only the numbers that begin with a 1. Then I'll want to sort or filter for only the numbers that begin with a 2, etc. There's got to be an easy way to do this, but I can't figure it out. Any help is appreciated. Thanks!!

50
128
9877
214
32475
17664
3421
...and so on



Posted by brian o'farrell on December 14, 2000 2:48 PM

A couple of ideas:
- format as text and sort then reformat as numbers if necessary
- use a hidden column to extract the first character and sort on that column