Format Date

[princy_varghese]

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

 

[Guest]

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

HTH
Jon

 

[princy_varghese]

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!!

 

[Fred Smith]

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 Data>Text 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.

 

[Lori]

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