Try this:

Select the cell(s) that are impacted
FormatCellsNumber tab
Category: Custom

Type: ddd
Returns: Mon, Tue, etc

Type: dddd
Returns: Monday, Tuesday, etc

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Captain" wrote:

How do I get a cell to show the day of the week when date entered.
Example:A1 = 01/02/2005, A2 should Show Monday or MON.
I have Excel 2000.