Forum Discussion
Formulas and Functions
I have combined the data from two banks to work on my taxes. On one set of data I cannot change the date format. Please help! I downloaded the data from each bank into an excel worksheet. When ...
Rather than bringing to exported files into Excel directly, I load them into PowerQuery for formatting and filtering and then load them individually or appended as suits you best. For me, it would be the US dates that cause problems but PQ allows the locale to be specified.