Forum Discussion
jsamodeo
Sep 08, 2021Copper Contributor
Changing the format of 10,000 dates
Hello, I need help changing the values of these dates from mm/dd/yyyy to dd/mm/yyyy. I have already tried changing the format via the ctrl 1 format cells method. This seems to get new dates in the ri...
jsamodeo
Sep 08, 2021Copper Contributor
So that changes how the box appears when hovered over, but it doesn't change the values at the top.
Wyn Hopkins
Sep 24, 2021MVP
Could you please make column C a lot wider so we can actually see the date in the cells in your screenshot
Thanks, that will help us answer
Thanks, that will help us answer
- Juliano-PetrukioSep 24, 2021Bronze ContributorThe date format was already solved. The only problem he was not considering is that the regional settings will be presented on formula bar. Well, this is not an issue.
In fact, his doubt was already solved.- Wyn HopkinsSep 24, 2021MVPAh I didn’t notice any reply or confirmation for the original poster ?