i have solution that has been working well untill, my customer ask that i change prices to dot, not comma, i re imported priceless table with dots, it imported fine ad on table view they appear good, problem is line items table the lookup field change number to thousand, e.g in priceless 971.70
and line items will appear as 9717 both are number fields and formatted as : as entered, i tried different data formatting still the same
the formatting in the inspector only sets the way the number will be displayed in a specific layout. It has no influence in the table where the number is saved.
Since 971.70 results in 9717, that means the setting in the file is to use ',' as the decimal separator for input. This is set at the file level.