Reply to thread

Message: [QUOTE="javamama, post: 3820835"] Hi, I believe there is a bug in excel 2007 for sorting function. I have a worksheet with the first column being a building code. Some of the codes consist of a number only(such as 1001), and some with a number and a letter(such as 1001a). my intent was to be able to sort these codes numerically, such as 1001, 1001a, 2000, etc. I painted down the column and did a format, format cells, text. Then tried to sort. excel put the numbers with letters after all the pure numbers, even though I attempted to format all the cells as text. I was able to find a work around: I inserted 2 columns to the left of my building code column. In the first column, I inserted the formula "=type(C1)". this column returned some type 1's (number) and some type 2's (text) even after I had painted down the column and formatted all the cells as text. Then I painted the building code column down and formated as number, then input "=text(C1,0)" in the 2nd column, which forced all the building codes to be type text. Then I was able to sort numerically. The point is that excel should have made all the building codes text when I painted down the column and did a format, format cells, text, but it didn't. Have you had other reports of this problem? ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. [URL]http://www.microsoft.com/office/community/en-us/default.mspx?mid=59b8c255-8799-43d9-beb9-e18a4a2f9bd9&dg=microsoft.public.excel.worksheet.functions[/URL] [/QUOTE]

Verification