Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
converting month name to number
0 views
Skip to first unread message
runsrealfast
Jun 13, 2006, 1:26:03 PM6/13/06
to
would like to convert a column that holds the name of a month
(January, February, etc) into a number (1, 2). Is there an easy way to
do this, you can't do enough if statemnts to do that. any suggestions?
(January, February, etc) into a number (1, 2). Is there an easy way to
do this, you can't do enough if statemnts to do that. any suggestions?
Bob Phillips
Jun 13, 2006, 1:34:35 PM6/13/06
to
Responded in excel.misc.
=MONTH(DATEVALUE("01-"&A21))
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"runsrealfast" <tay0...@yahoo.com> wrote in message
news:1150219563....@y43g2000cwc.googlegroups.com...
Ron Rosenfeld
Jun 13, 2006, 2:05:47 PM6/13/06
to
Here's one way:
=TEXT(DATEVALUE("1 " &A1&" 2000"),"m")
--ron
0 new messages