Convert Text To Number

J

John Calder

Hi

I run Excel 2K ans Windows XP

I have downloaded some numbers from a mainframe and they have come up as a
text format in the worksheet. I tried reformating them to a number but it
does not work. I also tried entering the number 1 in a cell and copying it
and then highlighting the numbers and slecting paste special thn using the
multiply option (i also tried the add option) but this did not work either.


Is there a simple way of converting numbers in a text format to a number
format in Excel 2K


Thanks
 
S

Shane Devenshire

Hi,

Select an empty cell and click Copy
Highlight the text number cells and choose Edit, Paste Special, Add
 
T

T. Valko

I also tried entering the number 1 in a cell and
copying it and then highlighting the numbers
and slecting paste special thn using the multiply option
Click to expand...

I guess you missed that.
 

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

Time to Number Conversion 2
Convert numbers stored as text to numbers - Automatically - Macro 2
Convert numbers stored as text to numbers - Automatically (NO Macrosor VBA) 0
Convert Text to CSV format 3
Time Formatting Question 4
Formatting cells with numbers and text 2
negative number format 1
Change number format from text to number? 2

Top