Hi,
I am from Australia and here we format our dates by DD/MM/YYYY
I have changed the locale setting in sheets to fix this, but when I make a report the date format is the default American type format. Iโve used a template and atttempted to change the language setting in hopes this will change it but it hasโnt. I am unable to format the template text itself because it is Formulas made from text.
Any Ideas?
Solved! Go to Solution.
Try to wrap your date value with the TEXT expression.
Try to wrap your date value with the TEXT expression.
User | Count |
---|---|
25 | |
25 | |
24 | |
21 | |
20 |