View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default date in a text cell

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