How to convert a label to numeric

Q

quickcarl83

Help!!!

I have a database created from my mainframe system. The databas
contains the names and ages of employees from a company. The ages ar
listed as labels. I want to convert them to numbers. I need a way t
do this. There are over 500 records and I don't want to do thi
individually. Any suggestions?

Car
 
R

Ron Coderre

See if this works for you:

Put a 1 in an empty cell
Copy that cell (Edit>Copy)
Select the range of text numbers
Edit>Paste Special>
Select:Multiply and Values
Click [OK]

Does that help?

Ron
 
H

Harald Staff

Hi Carl

Two approaches:

Enter 1 into a cell. Copy this cell. Select the troublesome ages. Go menu
Edit > pastespecial, check "multiply", OK.

Select the troublesome ages. Go menu Data > Text to columns. Click Finish.

HTH. Best wishes Harald

"quickcarl83" <[email protected]>
skrev i melding
news:[email protected]...
 
Top