I typed dddd(alt-0010)mm/dd/yyyy in Custom area and got a message that it is
an invalid format. Excel 2000.




"Dave Peterson" wrote in message
...
Just a couple of variations:

dddd* mm/dd/yyyy
(watch what happens when you widen the column.)

And
dddd(alt-0010)mm/dd/yyyy
And center it in the cell, and turn wrap text on.

You'll have to adjust the rowheight manually (and don't make the
columnwidth too
skinny!)

(for (alt-0010), hit and hold the alt key while typing 0010 on the numeric
keypad. You should see a little square for that character--until you turn
on
wrap text.)

icebreaker914 wrote:

Is it possible to list the day of week and calendar date in the same
cell?
If any one can help out it would be greatly appreciated!
--
icebreaker914

--

Dave Peterson