Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting text to numbers
IS there a way of converting text in a column of cells to numbers?
e.g. A 1 None 2 One 3 Two 4 Three 5 Four How do I convert that to 0,1,2,3,4 in an adjacent column of cells? John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting numbers to text | Excel Worksheet Functions | |||
Converting numbers formatted as text to numbers | Excel Discussion (Misc queries) | |||
Converting text to numbers | Excel Worksheet Functions | |||
converting numbers to text and prefill text field with 0's | Excel Discussion (Misc queries) | |||
Converting text to numbers | Excel Discussion (Misc queries) |