right click on the cell goto formate cells.

Click on the number tab then click on date in the left handed box and
select the stly you wish the date to be shown as.

You can also click custom and type the way you want the date, because
excel only really does american dates.

so for the uk it would be dd/mm/yyyy


---
Message posted from http://www.ExcelForum.com/