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"
skrev i melding
...

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