locked
Column validation on a number field RRS feed

  • Question

  • Hi,

    I have a number column that can have two decimal places. I've noticed that if a user inserts 24,40 everything is ok. But if they use a dot instead, like 24.40, the result is 2440,00 which is not ok. Now I want to validate if the number has dots. I've tried with =IF(ISNUMBER(FIND(".";[Balance]));FALSE;TRUE) but this always returns TRUE like the dost is somehow ignored. I've tried with regular expresions like it is here but then we have the same effect with commas - If the users inserts a dot, her or she gets a warning to use commas, and when using commas the result is like this: 24,40 gets transformed to 2440,00.

    Any idea how to solve this?

    Best regards,

    Sandra


    Sandra Ratis

    Thursday, September 27, 2012 1:28 PM

Answers