On 13 Jun 2006 10:26:03 -0700, "runsrealfast" wrote:

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?

Here's one way:

=TEXT(DATEVALUE("1 " &A1&" 2000"),"m")



--ron