Tim,

Try the following formula
=MONTH(DATEVALUE(Y1& " 1, 2003"))


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"_______Tim_______" wrote in 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