Sorting Problem

twoone · Apr 11th, 2002, 09:35 AM

When I try to "sort" by 2 different (number formatted) columns the top 3 numbers are not in the correct order. I have tried changing the formatting Category, but it still does the same thing. I have checked for spaces and odd characters.

HELP!
_________________
Larry

[ This Message was edited by: twoone on 2002-04-11 08:36 ]

Ian Mac · Apr 11th, 2002, 09:39 AM

Quote:

On 2002-04-11 08:35, twoone wrote:
When I try to "sort" by 2 different (number formatted) columns the top 3 numbers are not in the correct order. I have tried changing the formatting Category, but it still does the same thing. I have checked for spaces and odd characters.

HELP!
_________________
Larry

[ This Message was edited by: twoone on 2002-04-11 08:36 ]

what are the top three numbers? do you have field names?

twoone · Apr 11th, 2002, 09:46 AM

They are titled as below. This is "Item #" column that will not sort (top 3).
The "Shift" column is all "1"
SHIFT
1

ITEM #
411105
411172
411288
411010
411014
411034
411036
411038
411044
411045

zzydhf · Apr 11th, 2002, 09:47 AM

in another field, multiply the field by 1 and sort on that. I have hade this problem before and it was usually due to a "space" before or after the number.

Ian Mac · Apr 11th, 2002, 09:55 AM

Quote:

On 2002-04-11 08:46, twoone wrote:
They are titled as below. This is "Item #" column that will not sort (top 3).
The "Shift" column is all "1"
SHIFT
1

ITEM #
411105
411172
411288
411010
411014
411034
411036
411038
411044
411045

Could you do us this favour:

in a separate cell put = then
select an area that you have a problem with, so it say somthing like =A1:B40.

hit F9 and copy/paste the results here.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 09:35 AM	#1
twoone New Member Join Date: Apr 2002 Location: Larry Posts: 2	When I try to "sort" by 2 different (number formatted) columns the top 3 numbers are not in the correct order. I have tried changing the formatting Category, but it still does the same thing. I have checked for spaces and odd characters. HELP! _________________ Larry [ This Message was edited by: twoone on 2002-04-11 08:36 ]

Apr 11th, 2002, 09:46 AM	#3
twoone New Member Join Date: Apr 2002 Location: Larry Posts: 2	They are titled as below. This is "Item #" column that will not sort (top 3). The "Shift" column is all "1" SHIFT 1 ITEM # 411105 411172 411288 411010 411014 411034 411036 411038 411044 411045

Apr 11th, 2002, 09:47 AM	#4
zzydhf Board Regular Join Date: Apr 2002 Location: N.E. Ohio Posts: 236	in another field, multiply the field by 1 and sort on that. I have hade this problem before and it was usually due to a "space" before or after the number.