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

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?