change column properties from text to number

  • Thread starter Elizabeth Walling
  • 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.
 
A

Andy B

Hi

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

Andy.
 
Top