K
Kim
I have a datetime column which I have formated as a date, yet excel
keeps using a custom setting I did not choose.
I chose the date format for all previous rows in that column, but when
I insert new data in the next empty row excel will NOT use my
formating, which it should. The data is pasted in which excel
automatically performs a text-to-column function on, which is what I
want but I also want to use my manually picked datetime format for the
datetime column.
Execl 2007.
What can I do to get excel behave in this manner ?
keeps using a custom setting I did not choose.
I chose the date format for all previous rows in that column, but when
I insert new data in the next empty row excel will NOT use my
formating, which it should. The data is pasted in which excel
automatically performs a text-to-column function on, which is what I
want but I also want to use my manually picked datetime format for the
datetime column.
Execl 2007.
What can I do to get excel behave in this manner ?