Sep 08 2021 11:08 AM
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 right format, but I already have ~10k dates that need to be changed. Is there an easy way to do this?
Thanks for the help stranger =)
Sep 08 2021 11:44 AM
Sep 08 2021 11:53 AM
So that changes how the box appears when hovered over, but it doesn't change the values at the top.
Sep 08 2021 07:47 PM
Sep 24 2021 11:46 AM
Sep 24 2021 12:19 PM
Here is a suggestion with VBA (untested).
Should actually work.
Build a button into the sheet and let it run whenever you want ... is just a suggestion :)).
Sub Datechange()
Range("C1:C10000").NumberFormat = "dd/mm/yyyy"
End Sub
Hope I was able to help you with this info.
NikolinoDE
Was the answer useful? Mark them as helpful!
This will help all forum participants.
Sep 24 2021 12:53 PM
Sep 24 2021 01:02 PM
As was told before, it doesn't change because the regional settings of the computer.
You can change the view on the spreadsheet but if you click on the formula bar the date will be like was setup on regional settings.
Sep 24 2021 04:11 PM
Sep 24 2021 04:15 PM
Sep 24 2021 04:22 PM