View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone Jim Cone is offline
external usenet poster
 
Posts: 3,290
Default Sorting a six digit number by terminal digit

Brian,
You would have to use a macro to do that.
It would place reversed numbers in an adjoining column.
Sort the data using the new column data and then clear the column.
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html


"Brian"

wrote in message
Thanks Duke.
I was trying to avoid that.
Wondering if there is anyway to sort data in place?