How to convert a label to numeric

Help!!!

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

Carl

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

That works Ron. Thanks.

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]...
>
> Help!!!
>
> I have a database created from my mainframe system. The database
> contains the names and ages of employees from a company. The ages are
> listed as labels. I want to convert them to numbers. I need a way to
> do this. There are over 500 records and I don't want to do this
> individually. Any suggestions?
>
> Carl
>
>
> --
> quickcarl83
> ------------------------------------------------------------------------
> quickcarl83's Profile:
http://www.excelforum.com/member.php...o&userid=23949
> View this thread: http://www.excelforum.com/showthread...hreadid=375746
>