Connected Table - number import problem
Hello,
I setup a connected Table that contains decimal numbers using comma as decimal separator. The data looks like this:
When I create the table the fields are created as type "text" and the number value look like in the import file (1234,56).
After changing the field type to "Number - Currency" with the format "12.345.678,00" the number field will show the correct data 1.234,56 €.
I then update the import file to
ID,Num_1,
and trigger a refresh of the connected table.
After the refresh the value gets displayed as 223.456,00 €.
It seems like in the update process QB does not recognize the decimal separator any more.
Does anybody have an explanation or solution for this?
------------------------------
Martin Suske
------------------------------
I setup a connected Table that contains decimal numbers using comma as decimal separator. The data looks like this:
ID,Num_1
"1","1234,56"
When I create the table the fields are created as type "text" and the number value look like in the import file (1234,56).
After changing the field type to "Number - Currency" with the format "12.345.678,00" the number field will show the correct data 1.234,56 €.
I then update the import file to
ID,Num_1,
"1","2234,56"
and trigger a refresh of the connected table.
After the refresh the value gets displayed as 223.456,00 €.
It seems like in the update process QB does not recognize the decimal separator any more.
Does anybody have an explanation or solution for this?
------------------------------
Martin Suske
------------------------------
