this guy here at work has a list of dates that starts out at the source, then is moved into another application then back to feeder sheets which updates the source, which is now the target.
anyway the date column has 'NA' in cells and dates in others.
it seems when the column is moved to the target, the cells lose the date format because of the 'NA' and reads everything as text.
i just did a few tests and it seems like when doing a copy/paste Excel retains the format of the source. if that is so then probably they have to work their way back to make sure everything is formatted as Date.
anyway the date column has 'NA' in cells and dates in others.
it seems when the column is moved to the target, the cells lose the date format because of the 'NA' and reads everything as text.
i just did a few tests and it seems like when doing a copy/paste Excel retains the format of the source. if that is so then probably they have to work their way back to make sure everything is formatted as Date.