Text Function

[Guest]

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?

 

[Stevie_mac]

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

 

[CLR]

=TEXT(A1,"mmmm dd, yyyy") will return March 21, 2005 with 3/21/2005 in A1

Vaya con Dios,
Chuck, CABGx3