LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cathy
 
Posts: n/a
Default Change Month (words) to (numbers)

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting words with numbers in them jezzica85 Excel Discussion (Misc queries) 3 March 11th 06 04:36 AM
Converting words to numbers vstromer77 Excel Discussion (Misc queries) 3 February 6th 06 03:48 PM
SUMPRODUCT USING WORDS AS WELL AS NUMBERS FOR CRITERIA Andrew C Excel Worksheet Functions 2 December 29th 05 08:07 PM
Can you display numbers as words in excel (eg. 10 as ten)? Stefan White Excel Discussion (Misc queries) 2 October 5th 05 04:38 PM
how to change numbers into words, Mukesh Dhoot Excel Discussion (Misc queries) 1 March 19th 05 11:48 AM


All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"