software

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 !!Windows 98 doesn't tell us the version of Excel, but do try the instructions
under quot;Data Isn't Recognized...quot;
www.officearticles.com/excel/...soft_excel.htm
************
Hope it helps!
Anne Troy
www.OfficeArticles.com

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

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: www.excelforum.com/member.php...oamp;userid=31028
View this thread: www.excelforum.com/showthread...hreadid=506961