converting text to numbers

  • Thread starter Thread starter Tinnen
  • Start date Start date
T

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
 
Hi Tinnen

Copy a empty cell

Select your range and right click on it
Choose pastespecial..
And select Add
Ok
 
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
 
You might also need to be concerned about spaces. I've had to eliminate
leading & trailing spaces for this process to work. YRMV.
 
Back
Top