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

P

pdr

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

Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
Modern equivalent of Autotext in Word? 0
Centered text that does not stay centered 0
How to count the numbers in a Word document? 0
Inconsistent formatting of section numbers 0
Header Roman Numeral to Regular Numbers 1
Converting URLs in comments to Markdown-formatted links 2

Top