converting text to numbers

[Tinnen]

I would like to convert text to numbers.

I have a filed 123 that is text and I would like to
convert it into numbers.

/Tinnen

 

[Ron de Bruin]

Hi Tinnen

Copy a empty cell

Select your range and right click on it
Choose pastespecial..
And select Add
Ok

 

[RagDyer]

Right click in an empty cell and choose "Copy".
Select the range of cells that you wish to convert.
Right click in the selection and choose "PasteSpecial".
Then click on ADD, then <OK>.

Using an empty cell and ADD, eliminates the display of zeros where using a
cell with "1" and multiplying will show them in empty cells in the
selection.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I would like to convert text to numbers.

I have a filed 123 that is text and I would like to
convert it into numbers.

/Tinnen

 

[Greg Laskowski]

You might also need to be concerned about spaces. I've had to eliminate
leading & trailing spaces for this process to work. YRMV.