View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
William C. Smith William C. Smith is offline
external usenet poster
 
Posts: 9
Default Sortin Numbers as Text: How?

Thank you Rocky. Windows 2000 does have the Text to Columns feature and it
works!


"Rocky McKinley" wrote in
:

To sort numbers as text (as below) the range the numbers are in must
be formatted as text. If you have already entered the data then you
must either re-enter it or,

Select menu item:
Data / Text to Columns - then select next / next and then select
text in the last screen then /Finish.
I'm not sure if Excel 2000 has this feature I'm running Excel 2002.