Date and Time Formatting

Hi all,

I have a column in my worksheet that displays date and time in the following format:

DD:MM:YY HH:MM.

Any function i build into the worksheet using this column will take the HH:MM into account. Is there a fast way of editing this column to remove the HH:MM. I have tried various formats and the cell does not show the HH:MM but the data is still there. I am getting tired of manually editting these columns. I do not want to have to change the source sequel tables to not contain the HH:MM as this data is used occasionally.

Can anyone help??

thanks
brook

suppose your data is in column A starting from A1, then maybe in an empty column enter the formula

=DATE(YEAR(A1),MONTH(A1),DAY(A1))

and copy down, then simply copy this column and paste special in your original column


Mangesh

If you want to show the date as text ...... text(A1,"mm/dd/yy")
If you want to show the date as a value ...... value(text(A1,"mm/dd/yy"))