Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
250
Changing the decimal symbol and thousands separater
posted

Is it possible to change the decimal symbol and thousands separater?

I have a requiement to show the decimal point and seperater as potentially any other character specified by our users. Any ideas?

I have tried altering the format property of the column but this does not work correctly. So i have replaced the , with a : and the . with a  - in the format and this is the result.

:100-00 when the normal value is actually 10,000.00

Parents
  • 469350
    Suggested Answer
    Offline posted

    What's the DataType of the column you are working with?

    Assuming it's a numeric type, then you could apply a MaskInput on the column that picks up the system settings for the decimal and separator. But I don't think there's any easy way to specify particular characters that are not set in the system itself.

    I suppose another option would be to create an unbound column and then you could read the value from the "real" column and replace the decimals and separators with whatever you want and display them as a string in the unbound column. But then you would lose the ability to mask the input (assuming the field is editable).

Reply Children