JeffGrant
Well-known Member
- Joined
- Apr 7, 2021
- Messages
- 510
- Office Version
- 365
- Platform
- Windows
Hi all,
In Australia we use a date format of dd/mm/yyyy as one style that I use.
Using VBA, I use the DATE() function to add a date to rows and it correctly picks up the local date format of dd/mm/yyyy. No Problem.
However, when I add Sub-Totals, the Sub-Total Label as "mm/dd/yyyy Total" like this
and I don't know why.
Being upsidedown to the rest of the world, I really would prefer having the Sub Total labels in our format.
Any and all suggestions are greatly welcomed.
In Australia we use a date format of dd/mm/yyyy as one style that I use.
Using VBA, I use the DATE() function to add a date to rows and it correctly picks up the local date format of dd/mm/yyyy. No Problem.
However, when I add Sub-Totals, the Sub-Total Label as "mm/dd/yyyy Total" like this
and I don't know why.
Being upsidedown to the rest of the world, I really would prefer having the Sub Total labels in our format.
Any and all suggestions are greatly welcomed.