AnsweredAssumed Answered

comma instead of period

Question asked by Sumsar on Feb 13, 2010
Latest reply on Feb 13, 2010 by RSchaub

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

 

Outcomes