I currently have a macro which imports a data table into an excel file. One of the columns is a date column, but the dates are sometimes inconsistant. For example some are 14/02/2011 others would be 14/02/11.
Once imported excel doesn't know whether 14/02/11 means 2011 or 1911. And so I get the little green triangles in the top of each cell telling me to format it correctly.
The dates are always going to be 20** as it's current data (it's always going to be 2011 until next year).
Is there any way I can tell excel to always assume the data is 20**?
Thanks!
Once imported excel doesn't know whether 14/02/11 means 2011 or 1911. And so I get the little green triangles in the top of each cell telling me to format it correctly.
The dates are always going to be 20** as it's current data (it's always going to be 2011 until next year).
Is there any way I can tell excel to always assume the data is 20**?
Thanks!
