How to transform text to numbers.

[Emmes]

Hi
I have some information downloaded from a website into an excel file.
There's a colum with numbers wich cell format is general and I need them to
be numbers in order to apply formulas.
I've tried easy from changing the format cell (pretty obvious) till text to
columns, formulas, etc. Nothing works. In Excel 2003 worked with text to
columns.
Does anybody know what can I do?
TKS!

 

[DILipandey]

Hi Emmes

Two options for this:-
1. Select the numbers and multiply them with 1. For this type 1 somewhere
and copy it and then select the numbers you copied from Web and go to Edit -
Paste Speical - Values & Multiply.

2. Use formula =VALUE(reference), where reference is the reference to the
number which you have copied from web. After applying the formula, drag it
to the required range.

Thanks.
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India

 

[Pete_UK]

If you have downloaded those numbers from a website then you may have
the non-breaking space characters (code 160) in there. Highlight the
column(s) which contain these textual numbers, then CTRL-H (Find &
Replace), then:

Find what: Alt-0160
Replace with: (leave blank)
Click Replace All

where Alt-0160 means that you should hold down the Alt key while
typing 0160 on the numeric keypad.

Hope this helps.

Pete