General discussion
August 20, 2002 at 04:56 AM
mbertel

Excel File Not Sorting

by mbertel . Updated 24 years, 1 month ago

I have an acces table that was imported to an excel worksheet. I wish to sort by one column. What has been happening is the number without dashes are on the top of the column and the numbers with dashes appear at the bottem of the column. The only way to get a proper sort is to add a single quote symbol(‘) in each cell before the number in the particular I am trying to sort by and then it will sort properly. The proper sort being regardless of dashes or no dashes the numbers are in a propersort. Is there an easier way to make this happen? I appreciate any help on this. Thank you

Markus

This discussion is locked

All Comments