Discussion Locked

Excel File Not Sorting

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by dklippert

Depending on the layout of your data, you could use edit replace to get rid of all of the dashes and then use Format>Cell custom to display them with dashes.
###-###-####
Will display SS codes with dashes

This discussion is closed to new replies.