Sure. Go to Format - Cells - Number and choose a date format.

HTH
Jon


" wrote:

I have a cell in my worksheet that automatically comes up with a date
in the following format: -

23/10/2005 11:30:20 EST

I dont require the seconds and the EST in the cell is there a way I can
quickly delete these two unwanted details from the whole cell.

Thanks a lot

Princy