Why it's important
When importing costs, you need to import them with decimal places. Don't let Excel round it to the nearest whole dollar.
How to fix it
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.
Open the Excel file:
- Highlight the price column.
- Right-click and choose Format Cells.
- Choose Numbers instead of General.
- You can also highlight the column and use the Number dropdown on the HOME tab to scroll down to the Number format.
- The Excel file will now import with the correct number of decimal places.