Mick,

I don't use Excel 97 anymore but I think that Excel 2002 works approx. the
same way with regards to your problem.

  Type a date. Example 6/5/03 and you should get 6/15/2003. Leaving that
selected, find "cells" (probably under the "format" pull down) and you
should find a number category with different format selections.  Choose the
"Custom" selection and you should see this format m/d/yyyy which gives
you  the 6/15/2003 that you have already typed.  Change the day format so
that it looks this way: "m/ddd/yyyy" and you will get 6/Wed/2003 or if you
enter "m/dddd/yyyy" you will get 6/Wednesday/2003.

I hope this helps.

J. Dent




At 09:41 AM 8/4/2003 +0100, you wrote:
>Hello
>
>In one of my Excel 97 workbooks I have the date displayed for each entry. I
>would also like to display the day ... and so far I have been typing it in.
>I'd like to try and 'automate' it as I make many entries to the sheet per
>day and it would save time. I normally type in the date like 02 SEP 03, then
>Excel diplays it as 02-Sep-03 ... if it could display the relevant day as
>well this would be a real bonus for me.
>
>Is this possible?
>
>TIA ... Mick
>
>               The NOSPIN Group is now offering Free PC Tech
>                      support at our newest website:
>                           http://freepctech.com

                         PCSOFT's List Owner's:
                      Bob Wright<[log in to unmask]>
                       Drew Dunn<[log in to unmask]>