>I have choose Currency field type for one field in a table.
>I want to show only 2 decimal places but in the field there are 4 decimal places? Why? I have looked in Options/Regional/Currency and Number options and there it shows only 2 decimal places for currency.
>
>How can I fix that?
Where this really matters is in forms, for the end-user. Usually I change the InputMask for the corresponding TextField, for instance, to "###,###.##".
I am not sure whether the Control Panel's regional settings is supposed to control this aspect - or whether it does so - if you SET SYSFORMATS ON, but I usually don't worry about this.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)