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

    comma instead of period



      comma instead of period


      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.....