Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting Month name to a number
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting Month name to a number
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting Month name to a number
=MONTH(DATEVALUE("01-"&A21))
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "runsrealfast" wrote in message oups.com... 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
converting Month name to a number
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting Negative Number to Postive number | Excel Worksheet Functions | |||
calculating number of three month periods between two dates... | Excel Discussion (Misc queries) | |||
Function or formula to convert "text" month to number of month | Excel Discussion (Misc queries) | |||
How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
converting number string to number with decimal | Excel Worksheet Functions |