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