Amount fields in Excel
When you are using Excel as a tool for capturing data (import/export), note that Excel stores amount values differently than may be expected.
Values in Excel sheets are internally stored as XML (right-click any Excel > 7-Zip > open archive ...).
In the XML, values may be stored using a much finer degree of precision that what is displayed
Example 305.65 might stored as 305.64999999998.
Planon cannot alter these values coming from the XML.
Using Excel in Planon may result in a differences between Excel and Planon.
Workaround
• Change the format of all numeric cells in Excel to text.
Or, if this does not work...
• Prefix all numbers in all cells with apostrophe. An apostrophe before a cell value forces Excel to interpret the value as text. This is mostly useful for values that look like a number or date.
See also
See also