Data Sort Issues

Is there a way to reset or clean all format information from a sheet and start over? I have inventory data entered into ~115000 rows through P columns in Excel 2010. Information has been built from various sources i.e. converted from Access 2010, Excel 07, Excel 10. The primary sort fields are alphanumeric. My problem is that the information on the rows that I just moved from Excel 2010 from another computer will not sort. I took the columns in question and used =TEXT(a1,”###”) and converted the information to text in columns AA thru PP When I sorted this converted information, about 2000 rows of information which should have been dispersed throughout the list came to the top AND the location field which has an E as in 9E6 was converted to 9000000. I have about 60000 more rows to add but want to resolve this issue first. I need some ideas to try. Thanks for all advice.

Navanax1

Martin,
Thanks it appears to have worked. I will test further to see if I find problems.
navanax1

Martin,
Perhaps you can help and explain a issue that has popped up. I have used your equation =IF(ISTEXT(A1),A1,TEXT(A1,"###"))
very effectively but some of my information has an E in it like 8E10 or 5E1. The other data 8A1 8B1 8C1 all sort together but any field that has an E are grouped first in the 60,000 item field. It seems to think it is exponential. Any thought on how to correct?

Thanks,
Gene

Martin,
I will attach some of the data below. In looking further at the sort data if the item had an E like 8E1 or 11E9 I have a green triangle in top left with an exclamation point that says the number in this cell is formatted as text or is followed by an apostrophe. the rest of the fields that do not have a E like 10A1 do not have the triangle or comment.
I hope the data below is what you need.
Thanks,
Gene

8E1
8E1
8E1
8E1
8E1
8E1
8E1
8E1
11E9
11E9
11E9
11E9
11E9
11E9
11E9
11E9
10A1
10A1
10A1
10A1
10A1
10A1
10A1