If you are importing an Excel Order Guide and notice that the prices are rounding up this is because:
The Price column is saved as General in Excel, not as a number.
To fix this you should:
- Highlight the column in Excel
- Right click and choose Format Cells
- Choose Numbers instead of General.
- It will import the Excel file with the correct decimals and will not round up.