View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
jafsonic jafsonic is offline
external usenet poster
 
Posts: 10
Default sorting numbers as text

I hadn't had a chance to thank you all for the good suggestions.

Thanks

wrote:
Take this helper column:
=INT(--A1)*10+LEN(A1)-FIND(".",A1)--A1-INT(--A1)
Copy down.
Sort by this.

Regards,
Bernd