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
Bookmarks