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

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

Sorry but I have tried that it doesnot work, The column is imported
from an external source which I believe comes in a text format, I need
a way to change the whole cell quickly!!
Jon von der Heyden wrote:
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

If there is no quick way to do it, does that mean you're not interested in a
solution? Are we getting to the stage that, not only does the advice have to be
free and correct, it has to be quick?

I see three solutions, but none of them may fit your definition of quickly:

1. Use DataText to columns
2. Use the formula =left(a1,16) to pick off only the date and hh:mm portion of
your cell.
3. Convert the text to a date, then display it in whatever format you want.

--
Regards,
Fred


wrote in message
oups.com...
Sorry but I have tried that it doesnot work, The column is imported
from an external source which I believe comes in a text format, I need
a way to change the whole cell quickly!!
Jon von der Heyden wrote:
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

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