I use certain Excel templates daily for work, but I did not create them and so I'm not sure what the disconnect is.
Part of my job includes downloading a spreadsheet from a website and then copying and pasting the info to one of our Excel templates. Part of this information is a date. In the past, I was able to copy the mm/dd/yyyy date from the source and then paste it onto our template and it would remain mm/dd/yyyy. The source spreadsheet recently changed a little bit, and I was able to configure everything just fine except the date.
Now, when I paste it over, it becomes some random numbers that don't seem related. For example, 11/24/2026 becomes 46350, 12/3/2026 becomes 46359, 1/8/2027 becomes 46395, etc. Those numbers are reflected in the formula bar. I have NO IDEA what's causing this. Further, when I go to type the actual date into the cell, it just comes becomes a bunch of pound signs while the formula bar reflects the date I typed.
I'm usually good at poking around and figuring things out on my own, but I'm stumped. I know this probably has to do with our specific formatting, but can someone possibly point me in the right direction to get this fixed? Any ideas at all?
Edit: Solved, thank you! I widened the column and made sure the cells were formatted as date. Still have no idea why this changed, as everything was fine up until yesterday when the source updated their spreadsheet, but it is what it is!