View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
jstephenson
 
Posts: n/a
Default SORTING TEXT AND NUMBERS

i am trying to sort a non sequential list of numbers mixed with numbers
marked with an asterisk in front, such as on a bank statement of checks:

1224
1222
*1223
1221
1227
*1225
1228

and so on. When I sort, all of the numbers with an asterisk are grouped
together. I formatted them as text with the same result. Is there anything
i can do?