| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems Sorting
I am trying to sort data that was emailed to me. I am only trying to
sort one column in descending order and this is what it does: 387 399 4,192 4,457 416 423 424 439 456 474 480 491 5,074 5,645 519 What is wrong with my settings that it is sorting this way instead of: 5645 5064 4457 etc. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problems Sorting
Your source data is probably text numbers. Try this to convert it to real
numbers. Enter 1 in a blank cell, then copy the cell. Select the source col, right-click paste special check "Multiply" OK. It should sort properly now. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- wrote in message ups.com... I am trying to sort data that was emailed to me. I am only trying to sort one column in descending order and this is what it does: 387 399 4,192 4,457 416 423 424 439 456 474 480 491 5,074 5,645 519 What is wrong with my settings that it is sorting this way instead of: 5645 5064 4457 etc. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problems Sorting
Not necessary to enter 1 & copy, etc. Just select a blank cell, copy it,
paste special & click Add. "Max" wrote in message ... Your source data is probably text numbers. Try this to convert it to real numbers. Enter 1 in a blank cell, then copy the cell. Select the source col, right-click paste special check "Multiply" OK. It should sort properly now. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- wrote in message ups.com... I am trying to sort data that was emailed to me. I am only trying to sort one column in descending order and this is what it does: 387 399 4,192 4,457 416 423 424 439 456 474 480 491 5,074 5,645 519 What is wrong with my settings that it is sorting this way instead of: 5645 5064 4457 etc. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problems Sorting
Agree. We Just need to ensure it's really a blank cell that's copied, not
one which contains a zero length null string or a whitespace <g. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Bob Umlas" wrote in message ... Not necessary to enter 1 & copy, etc. Just select a blank cell, copy it, paste special & click Add. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problems Sorting
I tried doing this, but it still did not correct the problem? The data
comes from a website, which was copied into an excel document and then emailed to me. I've done this before and have never had problems? Can you think of anything else that would cause this problem? Thanks Max wrote: Your source data is probably text numbers. Try this to convert it to real numbers. Enter 1 in a blank cell, then copy the cell. Select the source col, right-click paste special check "Multiply" OK. It should sort properly now. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- wrote in message ups.com... I am trying to sort data that was emailed to me. I am only trying to sort one column in descending order and this is what it does: 387 399 4,192 4,457 416 423 424 439 456 474 480 491 5,074 5,645 519 What is wrong with my settings that it is sorting this way instead of: 5645 5064 4457 etc. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Problems Sorting
Try David McRitchie's TrimALL sub at:
http://www.mvps.org/dmcritchie/excel/join.htm#trimall -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- " wrote: I tried doing this, but it still did not correct the problem? The data comes from a website, which was copied into an excel document and then emailed to me. I've done this before and have never had problems? Can you think of anything else that would cause this problem? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems due to sorting | Excel Discussion (Misc queries) | |||
| Two problems sorting a database containing pictures | Excel Discussion (Misc queries) | |||
| Two problems sorting a database containing pictures | Excel Discussion (Misc queries) | |||
| Sorting Problems | Excel Discussion (Misc queries) | |||
| Problems with sorting a pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
