Excel Sorts Scientific Notation and Alphanumeric Values Incorrectly
Question details
The user needs to sort a mixed-value Excel column containing numeric, alphabetic, alphanumeric, and scientific-notation-like entries in the expected order.

- Product
- Microsoft Excel desktop
- Device & OS
- not provided
- Scenario
- A table includes values such as 7E1 alongside numbers and text. Sorting the column as text produces an unexpected order, while filtering appears to index the values correctly.
- Observed behavior
- Excel sorts the mixed column unexpectedly, particularly when scientific-notation-like values and alphanumeric entries are present. The behavior may differ by Excel build or installation.
Create a small copy of the workbook containing only the affected column and a few representative values, including entries such as 7E1. Check whether the cells are stored as numbers, text, or formulas before testing the sort.
Test the workbook in Excel for the web or another computer
Use this solution to determine whether the unexpected sort is caused by the workbook data or the installed Excel desktop build.
If the same file sorts correctly in Excel for the web or on another computer, the issue is more likely related to the local Excel installation or desktop build than to the sorting command itself.
Sign in to Microsoft 365, open Excel for the web, select Upload and open the test workbook, then select the affected column and choose Data > Sort A to Z or Data > Sort Z to A.
Compare the web result with the desktop result and record whether values such as 7E1 move to a different position.
Open the same test workbook in Excel on another computer and repeat the sort from Data > Sort.
If sorting works elsewhere, open Windows Settings > Apps > Installed apps, select Microsoft 365 or Office, choose Modify, and run an Online Repair. Install available Office updates before testing again.
Make the sort key consistent before sorting
Use this approach when the column intentionally mixes numbers, text, alphanumeric codes, and scientific-notation-like values.
Sort Mixed Numeric and Alphanumeric Data in WPS Spreadsheet
WPS Spreadsheet provides a free, lightweight alternative for opening the workbook, checking how values such as 7E1 are interpreted, standardizing the sort column, and sorting the complete table with a familiar spreadsheet interface. Its compatibility with Microsoft Excel formats supports a seamless migration for testing or everyday work.
- 1. Open the workbook in WPS Spreadsheet: Launch WPS Office, choose Spreadsheet, select Open, and load the affected XLS or XLSX workbook.
- 2. Check the affected values: Select the column containing entries such as 7E1 and review the formula bar and Home tab number format to identify how each value is stored.
- 3. Create a consistent sort key: Use a helper column and functions such as TEXT or VALUE, or use Data > Text to Columns, to convert the mixed entries into a consistent text or numeric format.
- 4. Sort the table: Select the complete table, open the Data tab, choose Sort, select the standardized column, and apply the required ascending or descending order.

Frequently Asked Questions
Why does Excel place 7E1 in an unexpected position when sorting?
Excel may interpret 7E1 as scientific notation representing a number, while other entries in the column may be stored as text. Mixed data types are compared differently during sorting, so standardize the column before sorting.
Why does filtering appear correct when sorting is wrong?
Filtering and sorting use different operations and may handle mixed data types differently. A filter can index the displayed values acceptably even when the sort order exposes inconsistent text and numeric storage.
How can I tell whether an Excel value is text or a number?
Select the cell and inspect the formula bar and Home > Number Format. You can also test a value with a formula such as =ISTEXT(A1) or =ISNUMBER(A1).
What should I do if the sort works in Excel for the web?
The desktop Excel installation or build may be causing the difference. Install Office updates, then open Windows Settings > Apps > Installed apps, select Microsoft 365 or Office, choose Modify, and run Online Repair.
Can WPS Spreadsheet open and sort my Excel workbook?
Yes. WPS Spreadsheet supports Microsoft Excel XLS and XLSX files. Open the workbook, check the data types, standardize the affected column if needed, and use Data > Sort on the complete table.




