hi guys,
i am average excel user and am having an issue.
I have some issues sorting a column.
Attached is a two sheet workbook:
on the first sheet is 5 columns (store #, Street, City, State, Zip)
on the second sheet i used this entry:
=Sheet1!A2 & " : " & Sheet1!B2 & ", " & Sheet1!C2 & ", " & Sheet1!D2 & " " & Sheet1!E2
(The attachment is set up as above)
When i then try and sort the sheet 2 column, it arranges the numbers very strangely, where 100 comes before 11, 23, and 7 for example.
The reason im concerned about the sorting is that i want to use the new column on sheet 2 in a pivot table that has other columns with store information.
When I create the pivot table and put the sheet 2 column in as a row label, it does the weird sorting.
I hope i am expressing my issue clearly. I would like it to sort in standard numerical order (1,2,3,...,9,10,11,...,98,98,100,...,199,200,201,...,etc)
I'd appreciate any help or suggestions
Bookmarks