I import text in to excel and in one cell its listed a such:
' 11-JAN-07

Now I have tried clearing the format and changing the cell to a date, but
the =month formula does not work. Do I did the following:

Cell A1 (' 11-JAN-07)
Cell B1 =A1
Cell C2 =month

Now I got that to work once and I have not been able to make it work again.
Help!!!