Excel Sort Doesn't Work
Good chance that Excel sees the "numbers" as text, especially if copied from
somewhere else.
Select the numbers and DataText to ColumnsFinish
Try the sort again.
Gord Dibben MS Excel MVP
On Sat, 22 Aug 2009 11:29:36 -0700 (PDT), PeterOut
wrote:
I am using MS Office Excel 2003 (11.8307.8221) SP3 on MS Windows XP
5.1 (build 2600.xpsp_sp3_gdr.090206-1234: SP 3).
I have the following list of numbers.
C-B
0.044991
0.012016
0.027636
0.187865
0.01452
-0.104374
I try to sort them by highlighting them and choosing Data:Sort
Sort by C-B. Header row, TRUE.
The numbers remain unchanged.
What gives?
Many thanks in advance,
Peter.
|