Assuming date in C1......

="My birthday is on " &TEXT(C1,"dd-mmm-yyyy")


Gord Dibben Excel MVP

On Tue, 6 Dec 2005 14:12:01 -0800, Dajana
wrote:

I need to show my date as 06-Dec-2005 in a text cell. Is it possible to have
a regular date format in a text cell.

Thanks