| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert mailing label into .xls | Excel Discussion (Misc queries) | |||
| Convert Alpha to Numeric | Excel Discussion (Misc queries) | |||
| convert a number in Excel from numeric to text, i.e. "1" to "one" | Excel Worksheet Functions | |||
| Convert Numeric into Text | Excel Worksheet Functions | |||
| convert numeric to text | Excel Worksheet Functions | |||
Threaded Mode
