Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Trisha
 
Posts: n/a
Default whats wrong with my sorting?

I am new to excel and I am trying to get numbers to sort ascending to
descending but there is stil #'s at the top that did not sort. Can anyone
please help me???
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Barb Reinhardt
 
Posts: n/a
Default whats wrong with my sorting?

Is it possible that you are sorting both text and numbers?

"Trisha" wrote in message
...
I am new to excel and I am trying to get numbers to sort ascending to
descending but there is stil #'s at the top that did not sort. Can anyone
please help me???



  #3   Report Post  
Posted to microsoft.public.excel.newusers
David McRitchie
 
Posts: n/a
Default whats wrong with my sorting?

Hi Trisha,
You might find some help and solutions with sorting problems in
http://www.mvps.org/dmcritchie/excel/sorting.htm

Excel more or less follows the ASCII collating sequence (number order of
characters) which places digits before the alpha characters, but Excel
also sorts all cells that the sort considers as numbers before the
cells that the sort considers as text.

When sorting you would generally be better off selecting all cells
on the sheet before invoking the sort -- the fact that Excel chooses
the current region (Ctrl+*) is a common problem that results in loss
of a useable worksheet -- hopefully you make that mistake only once
if you have to discover it yourself. The exceptions would be when
you want to sort only within a limited area and not carry other cells
in a row or column with a cell being moved when sorting.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Barb Reinhardt" wrote in message ...
Is it possible that you are sorting both text and numbers?

"Trisha" wrote in message
...
I am new to excel and I am trying to get numbers to sort ascending to
descending but there is stil #'s at the top that did not sort. Can anyone
please help me???





  #4   Report Post  
Posted to microsoft.public.excel.newusers
42410
 
Posts: n/a
Default whats wrong with my sorting?

As a further rider to this problem, I have also had a problem trying to sort
a column of numbers when some of them start with a zero. I've tried
formatting the cells as text, general, number and custom. None of them seem
to give consistantly correct sorting. What's the best way? Can anyone
advise?

(Sorry to piggy-back on someone else's posting, but my problem is in the
same context).


"David McRitchie" wrote in message
...
Hi Trisha,
You might find some help and solutions with sorting problems in
http://www.mvps.org/dmcritchie/excel/sorting.htm

Excel more or less follows the ASCII collating sequence (number order of

SNIP





  #5   Report Post  
Posted to microsoft.public.excel.newusers
42410
 
Posts: n/a
Default whats wrong with my sorting?

David Ritchie answered my problem in an earlier response to another
question:-

QUOTE
But formatting after entry does not change a number to text, nor text to
a number so changing the format would have no effect until reentered.
Reentering would remove leading zeros at least in Excel 2002.
UNQUOTE

Thanks David

Steve

"42410" wrote in message
...
As a further rider to this problem, I have also had a problem trying to

sort
a column of numbers when some of them start with a zero. I've tried
formatting the cells as text, general, number and custom. None of them

seem
to give consistantly correct sorting. What's the best way? Can anyone
advise?

(Sorry to piggy-back on someone else's posting, but my problem is in the
same context).


"David McRitchie" wrote in message
...
Hi Trisha,
You might find some help and solutions with sorting problems in
http://www.mvps.org/dmcritchie/excel/sorting.htm

Excel more or less follows the ASCII collating sequence (number order of

SNIP









  #6   Report Post  
Posted to microsoft.public.excel.newusers
42410
 
Posts: n/a
Default whats wrong with my sorting?

Sorry - I meant David Mc Ritchie!!

Steve

"42410" wrote in message
...
David Ritchie answered my problem in an earlier response to another
question:-

QUOTE
But formatting after entry does not change a number to text, nor text to
a number so changing the format would have no effect until reentered.
Reentering would remove leading zeros at least in Excel 2002.
UNQUOTE

Thanks David

Steve

"42410" wrote in message
...
As a further rider to this problem, I have also had a problem trying to

sort
a column of numbers when some of them start with a zero. I've tried
formatting the cells as text, general, number and custom. None of them

seem
to give consistantly correct sorting. What's the best way? Can anyone
advise?

(Sorry to piggy-back on someone else's posting, but my problem is in the
same context).


"David McRitchie" wrote in message
...
Hi Trisha,
You might find some help and solutions with sorting problems in
http://www.mvps.org/dmcritchie/excel/sorting.htm

Excel more or less follows the ASCII collating sequence (number order

of
SNIP









  #7   Report Post  
Posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default whats wrong with my sorting?

"42410" wrote:
... I have also had a problem trying to sort
a column of numbers when some of them start with a zero.
I've tried formatting the cells as text, general, number and custom.
None of them seem to give consistantly correct sorting. ..


Try this ..

Assuming source numbers in A1 down
Put in B1, say: =TEXT(A1,"000")
Copy down
Then sort both cols A and B by col B, ascending (say)
Delete col B

Adapt the part: "000" in the formula
to suit the maximum figure that is present in the source col A
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
Sorting 1, 1A, 2, 2A, 3, 4, 4A, 4B . . . agc1234 Excel Discussion (Misc queries) 6 May 26th 05 08:02 PM
sorting number in ascending order Janice Lee via OfficeKB.com Excel Discussion (Misc queries) 2 April 8th 05 10:31 PM
SORTING question Rebecca New Users to Excel 3 February 24th 05 06:35 PM
Adding a KeyID column for sorting Rebecca New Users to Excel 3 February 20th 05 08:09 PM


All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"