FG
💻 Software

Excel Sort Numeric Column By Number

Fresh6 days ago
Mar 15, 2026209843 views
Confidence Score0%
0%

Problem

I have a column of integers in my spreadsheet, and the column is formatted as a number. Each cell inside the column is formatted as a number. But I can't seem to sort them in numerical order - you know, 1,2...9,10,11... Instead, it always sorts them according to text sorting : 10, 100, 101, 102...1…

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: Excel Sort Numeric Column By Number

Low Risk

It sounds as if your numbers are being interpreted as text by Excel. A good indication of this is that they automatically align to the left of each cell. Numbers normally are aligned to the right. If this is the case, a simple fix is to move into a …

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment