Choose Edit Replace Find ':?? EST' and leave replace blank.

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