Thread
:
sorting numbers as text
View Single Post
#
8
Posted to microsoft.public.excel.programming
jafsonic
external usenet poster
Posts: 10
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
Reply With Quote
jafsonic
View Public Profile
Find all posts by jafsonic