=Text(A1, "mm/dd/yy")
--
HTH...

Jim Thomlinson


"SallyP" wrote:

Hi ,
I would like to convert my date which is formatted as mm/dd/yy to a text
format but i dont want to change the way the date looks. Currently every time
i convert it to a text the date turns into a number.

Can someone help me please