Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
month to number
Try this:
MsgBox Month(CDate("01-sty-2003")) Uzytkownik "_______Tim_______" napisal w wiadomosci ... Hi, Can you show me how to write a macro to convert a three place month abreviation, Jan, Feb, Mar, etc., in column Y into a number, 1, 2, 3, etc., in column AF? Thank You. Regards, Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
Converting Month Number to Month Text Abbreviation | Excel Worksheet Functions | |||
Function or formula to convert "text" month to number of month | Excel Discussion (Misc queries) | |||
show month number as month name in Excel? | Excel Discussion (Misc queries) | |||
How to extract month number from month name | Excel Discussion (Misc queries) |