Hi all,ng
Our company is a global company and I have the privilege of creating reports for both English(United States) and German(Austrian). My problem is the date format. US is mm/dd/yy whereas Austrian is dd/mm/yy. The user sends reports back to me with formula problems (the date format is changed when it is refreshed in Austria) but when I refresh it in US format, it works fine. Is there a way to create a report that will use the same date format no matter where the file is refreshed?
Thanks,
Sue Ann
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Sue Ann.
Are you using dates as filters? e.g., cell C5 has a date in it and a function in cell F7 references that
If so, are the dates formatted using an responding Excel format?
e.g., one with an asterisk:
so that the format will respond to changes in the regional date settings on the computer?
Please sign in to leave a comment.