3 Replies Latest reply on Feb 13, 2010 9:13 AM by RSchaub

    comma instead of period

    Sumsar

      Title

      comma instead of period

      Post

      I have made an invoice where i can import an csv file that will fill in the form.

       

      In the csv file all the amounts is made with a period instead of a comma (99.95 instead of 99,95)

      My problem is that filemaker dont´ see the period in a calculation. So i get some werry large amounts since 29.00 becomes 2900

       

       

      So i need either to make filemaker see the period so it will be 29.00 instead of 2900

       

      Or even better make the fields that contain the period(e.g. 29.00) become 29,00

       

      Hope that anyone can help.....