How to convert a label to numeric

[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

 

[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

 

[quickcarl83]

That works Ron. Thanks

 

[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]...