Number formatting for different countries
I recently deployed a solution in an office in Japan and discoverd that their currency has no fractions. Therefore I need to format all currency fields (in entry layouts and reports) to have 2 decimal places for USA but none for Japan.
It would be an ugly solution to duplicate hundreds of layouts for that purpose.
I am using filemaker pro 12
Any smart ideas ?