I have a macro that connects to Teradata database and with a query pull data into excel.
we have a set dates (a from date to a too date) that we need to pass as a text to the excel so it will read in the query. So, our dates are like this 20160101.
Is there a way to use vba to convert all the dates entered to text?
I tried this, but it jus keep it as dates (when I select a cell and look in the formula bar it shows as date 01/01/2016: