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?