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

If you format the cell as Text, then you'll have to type in what you
want--exactly the way you want to see it.

If you don't format it as text, you could type the date in anyway that's a date,
then use a custom format of:

dd-mmm-yyyy

(format|cells|number tab|custom category)

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

--

Dave Peterson

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