Thread: how do I sort a list a1 to a15, b1 to b15 etc
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ian Ian is offline
external usenet poster
  
Posts: 238
Default how do I sort a list a1 to a15, b1 to b15 etc
Change the cells to a01, a02... etc if possible.

--
Ian
--
"raypen" wrote in message
...
I need to sort a worksheet that has a column with a1 to a15 but normal sort
results in a1,a10,a11 not a1,a2 etc that I need


Reply With QuoteReply With Quote