How do I convert text to numbers in an old version of excel

G

Guest

I am downloading a page from an office program, it is formatted as a table.
When it copies (cut and paste) to excel some of the numbers come in as text.
In the never version it is easy to convert using the built in format
function. At home this works well as i need to link to another spreadsheet
which must have numbers. At work I cannot seem to get exel to convert or
recognize the cells as numbers...HELP PLease At work the pc is windows 98
sec edition. I am at wits end !!
 
M

mickbarry

If text number is in A1 then the formula =A1*1 should do the trick
regards Mick
Everyday I beat my own previous record for number of consecutive day
I've stayed alive
 

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

how do I convert an imported number to text 1
Excel Convert word into numbers and back 4
Convert Decimal fractions to binary and vice versa 1
Convert Number to Text for Index/Match 1
Convert text entered as minutes/seconds to minutes 1
Convert number to text as displayed 3
Convert Text to Numbers 2
how to convert list of numbers to barcode font 1

Top