From Kb_JMY(晉明夷)

FAQ

How to sort together related data like 77, 7789, 7798...?

• Ref:

1. openoffice.org -- How to sort together related data like 77, 7789, 7798...?
2. microsoft.com -- How to sort together related data like 77, 7789, 7798...?

• (a) Ans: for Microsoft Excel

• assume the data are in column A1 and beneth. Enter in cell B1: =TEXT(A1,"0")

-> copy the cell "B1" -> select the whole column B -> and paste

• Sort the data by column B

-> click on menu "data" -> sort -> expand data range

-> click on "sort" -> "ok" -> select "sort numbers stored as text separately"

• That's it!

• (b) Ans: for OpenOffice

-> do the same as in (a), except cell B1: =TEXT(A1;"@")