Column formatting not accepted

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Week not sorted correctly 2
Date Formatting 2
Matching Names 5
Moving data between columns 7
This is not a question about C# but a simple question about SQL query 6
Columns formatted As Dates Are Exported as a Number to Text 1
Sort by column, not range 1
Sorting dates in the format Jan Feb Mar Apr ... ??? 4

Back
Top