Convert text to number

  • Thread starter Thread starter Ivor Williams
  • Start date Start date
I

Ivor Williams

I have a column with about 13,000 numbers stored as text. How can I convert
all these to numbers without doing them individually?

Ivor
 
Hi
- copy a blank cell
- select your values
- use 'Edit - Paste Special' and choose the action 'Add'
 
Hi Ivor

one method
select a blank cell (maybe on a different worksheet to ensure that its
formatting is unchanged from default) and copy it
now select your numbers and choose edit / paste special - ADD
click OK
and they should now be numbers

Cheers
JulieD
 
Back
Top