sort order (excel 2003)

Topic

New Reply

how to sort 1-14 in following order please
9
8
7
6
5
4
3
2
14
13
12
11
10
1

Reply | Quote

Replies

Convert numbers to text using the =TEXT(A1,”#”) function and sort in descending order.

Reply | Quote

Convert numbers to text using the =TEXT(A1,”#”) function and sort in descending order.

Reply | Quote

Two methods:

1. Format the range of cells as Text before entering the numbers. Enter the numbers 1 to 14 in any order, then sort descending.

2. Enter the numbers as ‘1, ‘2, etc., up to ’14. The apostrophes won’t be displayed, but they force Excel to treat the numbers as text. Then sort descending.

Reply | Quote

Two methods:

1. Format the range of cells as Text before entering the numbers. Enter the numbers 1 to 14 in any order, then sort descending.

2. Enter the numbers as ‘1, ‘2, etc., up to ’14. The apostrophes won’t be displayed, but they force Excel to treat the numbers as text. Then sort descending.

Reply | Quote

thank you.

Reply | Quote

thank you.

Reply | Quote