change column properties from text to number

  • Thread starter Thread starter Elizabeth Walling
  • Start date Start date
E

Elizabeth Walling

I am collating keyword info which I have cut and pasted into excel. There
are two columns: 1. Has ranking number of key word (shown as a number but in
text format) and 2. the keyword itself.

I want to altar the 1st column to number format so that I can sort the
results by the ranking number.
 
Hi

Copy a blank, unused cell. Select the range you want to change and Edit /
Paste / Special / Add

Andy.
 
You must log in or register to reply here.

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

ranking numbers in a column 7
Changing Text To Numbers ? 1
Numbers showing Up Centered in Cell ? 1
Macro to add numbers in a text string 5
Columns formatted As Dates Are Exported as a Number to Text 1
Copy and pasted numbers not acting like numbers 2
Formatting Text to Numbers for Dates 2
Convert text to number automatically 1

Back
Top