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 I sort the combined files by date--the 'dates' block the integration of the files.
The dates on the first bank can be formated using the format tool. The 2nd bank has a mm/dd/YYYY format that cannot be adjusted to match the other file--and our template does not include an xx/xx/xxxx format. Is there a way that I can delete the second formating? Those slashes are killing me!
2 Replies
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.
The dates that won't be formatted are probably text values.
Select those dates.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then twice click Next >.
In step 3, select MDY from the Date drop-down.
Click Finish.
Apply the desired format.
