Dates incorrectly pasting from financial statements
I'm attempting to use a new excel budget spreadsheet for tracking my expenses (linked here). In the sheet labelled "expense data," you are supposed to be able to copy/paste the transactions from your .csv bank statement with dates and other info. The problem I'm running into is that the dates don't seem to be registering as dates, and they are all flagged with a "data validation error." Even though the spreadsheet title says to paste them as MM-DD-YYYY, the only way it will accept the dates is as YYYY-MM-DD, or if I type the full date (e.g., March 6, 2026) it will automatically put it in YYYY-MM-DD format.
So far, I've tried every single option from the "Paste Special" options and none of them paste the date in a format that is recognized as a date.
I'm wondering if there is an easier way to help excel recognize these dates other than manually re-typing each one.
For context, I am using Excel on a Mac. My dad uses the same spreadsheet (and transfers info from the same bank) on a Windows computer and doesn't run into the same issue. Thanks in advance :)
[link] [comments]
Want to read more?
Check out the full article on the original site