Number Format Problem Prevents Proper Sorting

6

65Stang

I have a long list of numbers that were exported from anothe
application that I can't seem to format properly to sort in ascendin
order. I have changed the format from General to Number and back wit
no success. I'm sure that this is an easy fix, but I'm not seeing th
answer. The third entry below (1103) should be toward the top of th
list. Any ideas?


110272
110277
1103
110329
110338
11033
 
M

mzehr

Hi,
First make a copy of your workbook so that any changes made don't destroy
your original if things don't look correct. It looks like these numbers were
imported as text. First look to see if there is a ' in front of the number.
If so, do a find and replace with "". Make sure that the column is formated
as number. Should that fail, consider inserting a helper column and paste
and copy this formula down the length of the column =VALUE(a1).
Then copy and paste special - values over the original data. Eliminate your
helper column. Then re-sort.
 
Top