VAT excel export - Date column should default to date format
Dates should default to date format when exporting the VAT return to excel.
Currently when exporting the VAT return to excel that dates automatically default to either text or general format. This means you can't filter the dates by oldest to newest as the filter selection defaults to A-Z.
Changing the date to date format via format cells does not fix the issue. The only way I have found is to manually update the dates using the =DATEVALUE(x) formula and paste these new values over the old ones. This can be very tedious when working with a lot of late claims etc.
4
votes
Megan Scott
shared this idea