I am importing some data with a MS QUERY from another workbook and the data is put into a table called CUSTOMERS.
The listobject has several columns and one of them is "First Order Date".
There is one value that I want to remove (not hide with a cell format): 00.01.1900 00:00:00
Is there a neat way to delete this value in the entire listobject with VBA?
I do not mind if the data is converted to a string if that makes it easier and the cell is empty