View Single Post
  #7   Report Post  
Anne Troy
 
Posts: n/a
Default I need Excel to make "1" into "001"

Yep. The value is the sort order, not the display.
************
Anne Troy
www.OfficeArticles.com

"Terry" wrote in message
...
I just change cell format to text it works, however when I sort them
latter,
numerical data and text data they sory separately.

Will the way you guys provide can deal the problem of latter sorting?