"Ron Coderre" wrote:

With
A1: (a month name....eg March)

Try this
=MONTH("01-"&A17)

Sorry Ron but I can't get that to work. A17 must be an error, right?

In my example the formula returns: 3


Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

"Mats Samson" wrote in message
...
How do I transfer the month name February in a cell to its corresponding
number 2, March to 3, etc, so I can use it in a formula in another cell?