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

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 !!

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

Windows 98 doesn't tell us the version of Excel, but do try the instructions
under "Data Isn't Recognized..."
http://www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"pdr" wrote in message
...
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 !!

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

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 days
I've stayed alive.


--
mickbarry
------------------------------------------------------------------------
mickbarry's Profile: http://www.excelforum.com/member.php...o&userid=31028
View this thread: http://www.excelforum.com/showthread...hreadid=506961