software

Is there anyway to format the cell so when I enter a date the cell will
show the weekday along with the date? For instance, if I enter
04/04/2006 into the cell, the cell will show quot;Wed 04/04/06quot;.--
Rutgers_Excels
------------------------------------------------------------------------
Rutgers_Excels's Profile: www.excelforum.com/member.php...foamp;userid=8973
View this thread: www.excelforum.com/showthread...hreadid=530037Use the following number format.

ddd mm/dd/yy

quot;Rutgers_Excelsquot; wrote:

gt;
gt; Is there anyway to format the cell so when I enter a date the cell will
gt; show the weekday along with the date? For instance, if I enter
gt; 04/04/2006 into the cell, the cell will show quot;Wed 04/04/06quot;.
gt;
gt;
gt; --
gt; Rutgers_Excels
gt; ------------------------------------------------------------------------
gt; Rutgers_Excels's Profile: www.excelforum.com/member.php...foamp;userid=8973
gt; View this thread: www.excelforum.com/showthread...hreadid=530037
gt;
gt;

I'm assuming that you didn't mean for it to say quot;Wedquot;, when 4/4/06 is really
a Tuesday.

quot;Rutgers_Excelsquot; wrote:

gt;
gt; Is there anyway to format the cell so when I enter a date the cell will
gt; show the weekday along with the date? For instance, if I enter
gt; 04/04/2006 into the cell, the cell will show quot;Wed 04/04/06quot;.
gt;
gt;
gt; --
gt; Rutgers_Excels
gt; ------------------------------------------------------------------------
gt; Rutgers_Excels's Profile: www.excelforum.com/member.php...foamp;userid=8973
gt; View this thread: www.excelforum.com/showthread...hreadid=530037
gt;
gt;


You assumed correctly. I haven't changed my calander since yesterday.
Thanks for the help. Sometimes I overthink these little things and I
wind up not being able to see the forest for the trees.--
Rutgers_Excels
------------------------------------------------------------------------
Rutgers_Excels's Profile: www.excelforum.com/member.php...foamp;userid=8973
View this thread: www.excelforum.com/showthread...hreadid=530037