Is =TEXT(J11,"dd-mmmm-yyyy") any good for you?

"Chris Huisken" wrote in message
...
I have a date entered in a cell in the format 3/31/2005. I am trying to
change this to text using =text(reference cell, "date") but the result coming
into the cell is 31at2005. How do I change this?