I 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?
I 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?
How about:
=MONTH(DATEVALUE(A1&" 1"))
Where A1 holds that month string.
runsrealfast wrote:
>
> I 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?
--
Dave Peterson
=MONTH(DATEVALUE("01-"&A21))
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
"runsrealfast" <[email protected]> wrote in message
news:[email protected]...
> I 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?
>
If colomn A has month then try:
=MONTH(DATEVALUE("01/" & A1 & "/2006")) and copy down
HTH
"runsrealfast" wrote:
> I 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?
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks