Sorting Numbers with letter suffixes
On Wednesday, February 27, 2008 at 4:42:44 AM UTC-5, Terry Bennett wrote:
Thanks again guys for the suggestions - much appreciated.
"Terry Bennett" wrote in message
Is there a way I can sort numbers such that if I have a letter suffix (ie;
2A, 3B, etc), they are sorted after the original number, ie; 2A between 2
and 3 then 3B between 3 and 4?
Change the data type to Plain text instead of Auto. Then when you sort it does it correctly.