I created a table where one of the columns is UnitPrice and it is set as type decimal with 2 decimal places. When I copy a calc file and append the data to my table the unit price is shifted by 2 decimal places. My steps are as follows:
1 Select the data
2 Right-click on my table a do a paste
3 Under “Options” I select the radio button “Append data” with nothing else checked
4 Under “Assigned Columns” all are checked and the first line looks correct (the unit price shows 1.58)
5 After clicking create and opening the table the unit price shows 0.01
If I create the table and make UnitPrice a decimal with 1 decimal place the 1.58 comes out as 0.1 after appending.
How do I append a column of prices without the value being shifted?