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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting text to numbers
Hi,
It depends how many of these text values you have but one way is to create a table of text and numbers like this:- None 0 One 1 Two 2 three 3 four 4 In my case these are in E1 to F5 and you can add as many as you want to this list. To convert a number in A1 put this in B1. To convert a column simply drag down =VLOOKUP(A1,$E$1:$F$5,2,FALSE) Mike "JRD" wrote: 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 |
Reply |
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) |