>Situation: I Concatenate two cells that each have values from different
>Formulas [Example:
>J1=COUNTIF($B1:$G50,B51),K1=COUNTIF($B41:$G50,B51),L1=CONCATENATE($J1,$K1)]
>J2=COUNTIF($B2:$G51,C51),K2=COUNTIF($B42:$G51,C51),L2=CONCATENATE($J1,$K1)]
>,etc.   then Copy/Paste Special/Value into another column.

>Problem: I Sort but do not get a "true" Sort.

>Attempted Resolution: Change all the Cells to a Numeric Format, then do Sort.

>Results: Still no "true" Sort.

>Results Example:(Sort in Descending Order)

>                           50
>                           50
>                           41
>                           41
>                           40
>                           40
>                           32
>                           31
>                           30
>                           21
>                           20
>                           116  <--- should be at top of Sort since it has
>highest value
>                           114  <--- should be 2nd from top
>                           113  <--- should be 3rd from top
>                           102  <--- should be 4th from top
>                           10

>Any suggestions on how to fix this?

> Situation: I Concatenate two cells that each have values from different
> Formulas [Example:
> J1=COUNTIF($B1:$G50,B51),K1=COUNTIF($B41:$G50,B51),L1=CONCATENATE($J1,$K1)]
> J2=COUNTIF($B2:$G51,C51),K2=COUNTIF($B42:$G51,C51),L2=CONCATENATE($J1,$K1)]
> ,etc.   then Copy/Paste Special/Value into another column.

> Problem: I Sort but do not get a "true" Sort.

> Attempted Resolution: Change all the Cells to a Numeric Format, then do Sort.

> Results: Still no "true" Sort.

> Results Example:(Sort in Descending Order)

>                            50
>                            50
>                            41
>                            41
>                            40
>                            40
>                            32
>                            31
>                            30
>                            21
>                            20
>                            116  <--- should be at top of Sort since it has
> highest value
>                            114  <--- should be 2nd from top
>                            113  <--- should be 3rd from top
>                            102  <--- should be 4th from top
>                            10

> Any suggestions on how to fix this?

>> I'm having trouble getting a good Sort.

>> Situation: I Concatenate two cells that each have values from different
>> Formulas [Example:
>> J1=COUNTIF($B1:$G50,B51),K1=COUNTIF($B41:$G50,B51),L1=CONCATENATE($J1,$K1)]
>> J2=COUNTIF($B2:$G51,C51),K2=COUNTIF($B42:$G51,C51),L2=CONCATENATE($J1,$K1)]
>> ,etc.   then Copy/Paste Special/Value into another column.

>> Problem: I Sort but do not get a "true" Sort.

>> Attempted Resolution: Change all the Cells to a Numeric Format, then do Sort.

>> Results: Still no "true" Sort.

>> Results Example:(Sort in Descending Order)

>>                            50
>>                            50
>>                            41
>>                            41
>>                            40
>>                            40
>>                            32
>>                            31
>>                            30
>>                            21
>>                            20
>>                            116  <--- should be at top of Sort since it has
>> highest value
>>                            114  <--- should be 2nd from top
>>                            113  <--- should be 3rd from top
>>                            102  <--- should be 4th from top
>>                            10

>> Any suggestions on how to fix this?

>The numbers are still being STORED as text, no matter how you format
>them. One way to convert them to numbers would be to add "*1" (times 1)
>to your concatenate string - it will force XL to coerce the string to
>numeric.