Convert text to numbers

  • Thread starter Thread starter yahoo
  • Start date Start date
Y

yahoo

Hi

I have a column of numbers in text format - I need to change them to
number format

When I goto Format ->cells to change - it does not work
Is there another way to change?

Thanks
 
Hi
- copy an empty cell
- select your values
- goto 'Edit - Paste Special' and choose 'Add'
 
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

Index/Match with text-looking numbers 1
convert text to values 7
Converting Text to Number by formula (Opposite to Text("000",A1) ) 3
Excel 2007 paste data, need to convert to numbers 3
Can't Explain N/A in Vlookup 2
converting numbers to text 2
Need Adaptable Macro 9
converting text to proper dates 6

Back
Top