See your previous posts.

Regards,
Fred

"Excellency" wrote in message
...
I am trying to convert text to month and year. In the cell it displays as
07/09 i want it show Jul-2009 or 2009-Jul. When i use DATEVALUE or DATE it
adds current year and displays something like 02/15/2010. Any idea what i
am
doing wrong..

thanks