Hi Pam

Use this then

ActiveCell.NumberFormat = "dddd mm/dd/yyyy"


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Pam M" wrote in message ...
I used Ron's calendar control and it is slick! I can see in the click-event
that the date is custom formatted to mm/dd/yyyy. I want to add the day of
the week in front of the date. Is it as simple as changing this line of the
macro, and if so, what should it say? Thanks so much, Pam