Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have a column with the month as the full word (January or February, etc.).
I need to translate the words to numbers in a separate column (1 or 2, etc.) I haven't been able to find a function that can help perform this task. "If" statements will not go further than 8 levels. The month function will not recognize it because it's not part of a full date. What other options do I have? I feel like I'm missing something obvious here... Thank you, Cathy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting words with numbers in them | Excel Discussion (Misc queries) | |||
Converting words to numbers | Excel Discussion (Misc queries) | |||
SUMPRODUCT USING WORDS AS WELL AS NUMBERS FOR CRITERIA | Excel Worksheet Functions | |||
Can you display numbers as words in excel (eg. 10 as ten)? | Excel Discussion (Misc queries) | |||
how to change numbers into words, | Excel Discussion (Misc queries) |