Try something like this:

Select the impacted cells
FormatCellsNumber tab
Category: custom
Type: ddd mm/dd/yyyy
Click the [OK] button

Does that help?

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

XL2002, WinXP-Pro


"sharkey" wrote:

I need to show the day and the date in the same cell

tue 27/02/06
wed 28/02/06

can anyone help please