Column formatting not accepted

M

millarg

Good morning, I regularly export from Quickbooks to Excel 2000. I create a primary key 1,2,3,4, in the first column in order to assist with some sorting that I wish to complete.
When finished I sort by the primary key which now lists as follows 1,10,11...2,20,21 - I have changed the formatting of the column with no luck - Any advice much appreciated - Glen
 
D

Dave Peterson

It's not enough to just reformat the column.

Try formatting the column as General
then select an empty cell
Edit|copy
select your column again
and edit|paste special|and Check Add (under operation)
 
Top