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 ...
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.