timcheng616
New Member
- Joined
- Apr 1, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
I have a long list of dates formatted with zeros in front of the month. So Pivot tables doesn't register them as a date. So I'd like to change the format (i.e. from 02/14/2022 to 2/14/2022). I did try to go into formatting and change it from "general" to "date." But nothing changes
the only way it seems to register it as a date is if I go into the cell move my cursor to the end and then hit "Enter" then it converts to a date. I don't want to do this manually for every single one. Is there a way for me to convert this to dates?
Thanks.
the only way it seems to register it as a date is if I go into the cell move my cursor to the end and then hit "Enter" then it converts to a date. I don't want to do this manually for every single one. Is there a way for me to convert this to dates?
Thanks.