Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
convert text to number in excel
I have one of four chars displayed in any cell "f", "p", "m", "d", i wish to
convert "f" to 0 "p" to 1 "m" to 2 and "d" to 3 then compare to a second set of cells. The second set of cells value can also be "f", "p", "m", "d" which i need to convert to the same set of numbers. i will then use autoformat in a third cell to determine if the second set of cells is higher in value than the first or lower in value The Teacher |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
number convert to text in excel | Excel Discussion (Misc queries) | |||
can we convert number to text in excel as if 1= One | Excel Discussion (Misc queries) | |||
How do I convert a number in Excel to text? | Excel Worksheet Functions | |||
In Excel, how do we convert text into number (value)? | Excel Worksheet Functions | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) |