Forum Discussion
Is there a formula to fix this issue
I actually wrote to my bank's Pres. about this: When I download any report from my local bank, the first thing I want to do is sort it by the DATE field. However, their field for DATE is formatted as...
Select the Date column.
On the Data tab of the ribbon, click Text to Columns.
Select Delimited, then click 'Next >'.
Clear all check boxes for the delimiters (Tab, Comma, etc.), then click 'Next >.
Select MDY from the Date drop-down, then click Finish.
Does that help?
Thank you SO MUCH! This has been a thorn in my side for years. So grateful for your invaluable help and expertise. What is this process called? In COBOL, we called it "Reference Modification."
I don't think there is a specific name for it in Excel...