Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SORTING DATA
I WISH TO SORT THE FOLLOWING DATA:
1001 1001P 1002 1002P ETC WHEN I DO A SORT IT SORTS AS FOLLOWS" 1001 1002 1001P 1002P THIS IS NOT CORRECT, PLEASE HELP, VERY FRUSTRATING |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SORTING DATA
Robert
Excel is sorting properly. Sorts numbers before text which is the nature of your data. If you want to sort by number, you will have to break the mixed cells into two cells and sort on the numbers. Gord Dibben MS Excel MVP On Sat, 24 Jun 2006 06:08:01 -0700, ROBERT H <ROBERT wrote: I WISH TO SORT THE FOLLOWING DATA: 1001 1001P 1002 1002P ETC WHEN I DO A SORT IT SORTS AS FOLLOWS" 1001 1002 1001P 1002P THIS IS NOT CORRECT, PLEASE HELP, VERY FRUSTRATING |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
sorting data and automatic graphs | Charts and Charting in Excel | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Automatically sorting data | Excel Discussion (Misc queries) | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) |