Change the format to "dd/mmm/yy, ddd"

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"mlm" wrote in message
...
Hello,

In a cell, i have a date format as dd/mm/yy..
how do i add to that to take the "dd" and also show the
text "day" of that date?
ie: 22/Feb/04, Sun.
i have seen it somewhere..
forget what it was.
i tried several but get errors or none at all.
thanks.