Forum Discussion
Change Date Type in Excel
Hey, guys. My doubt is kinda basic, but I'd much like to have some help. I have a sheet with some data and I'm creatin a pivot table with this data. The problem I'm facing is that, although I...
Hi, diogoferreiraac
A few suggestions for now:
- Check if there are any extra spaces in any of the date cells at the beginning or the end of the number.
- Check if any of the date values are just a number format and has a proper date value on the cell.
- If you can, create an extra column on your date that transforms the date numbers you currently have to the format you need. Then use that column on your pivot table.
I hope that any of these tips help. Good luck!