Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
month to number
WOW.
Thank you all so much for taking the time to look at this. I am using Rockys solution because I sort of understand it a little. :) And I am trying to learn new ways to replace pulling down formulas through 5,000 - 10,000 rows of data per sheet. If anyone knows an alternative to pulling down 30 columns of formulas through 10,000 rows of new data, please, please, please let me know. Regards, Tim -----Original Message----- 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 . |
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) |