User Profile
MichelleL1
Copper Contributor
Joined Sep 12, 2023
User Widgets
Recent Discussions
Improper Date Format from Data Validation List
Hello Community! For some odd reason, I am the only member of a team with this issue from a SharePoint excel file. The excel file has a data validation list from a drop-down window of dates to select. When I select the date/year option, the list returns the wrong date format which causes the macros in the excel file to blow up and not properly execute (e.g. list has Jan '24 to populate January); however, the date that returns for me is Jan '24, not January that causes the macro to work. I am the only team member that has this problem. I checked the cell format against other team members and it appears the cell is formatted the same. Attached is a copy of the date cell in red. I have also attached the cell formula that works for other team mates. Please help! Oh, btw, the IT Helpdesk
