Text Function

C

Chris Huisken

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?
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
Top