When editing price charts in Excel, values have many numbers after decimal point

When editing price charts in Excel, values have many numbers after decimal point


When editing price charts in Excel the value in some of the cells has many numbers after the decimal point, instead of just two as you would expect.

For example, Excel shows 550.058999741077 instead of 550.06.


There are two possible causes of this.

Product Designer

When you perform certain functions in Product Designer such as increasing by a percent, PD does not round the results when it saves the value back into the chart. It is rounded when displayed in the grid but the actual value is sent to Excel which is why Excel shows the large, un-rounded value.

Original spreadsheet has the large values

Some price charts that Solatech uses came directly from Excel spreadsheets that the manufacturers created. Some of these spreadsheets have un-rounded numbers due to the way they were created. Product Designer carries over the actual number.


Use the rounding functions in Product Designer to round the values up or down to the nearest appropriate value. For example if you round 575.0456 down to the nearest 1.00 it will change the value to 575.00.

Changing the display settings in Excel only changes how the number is displayed, it does not change the actual value itself.

There are ways to do this in Excel also:

1 - Highlight a blank cell and click the fx button.

2 - Choose Round as the function.

3 - For the top number choose the cell you want to round, the second space type a 0 (number of digits).

4 - Click OK.  You will have your rounded number.

5 - for the rest of the chart, just copy the cell you just did and paste it everywhere else.

When SWCS calculates prices it automatically rounds the values to two decimal places.

Applies To:

  • Product Designer 4.0
  • Product Designer 4.1
  • Product Designer 4.2

    • Related Articles

    • How to Import a Price Chart from Excel

      Summary  This article will explain how to take a price chart from an excel spreadsheet and import it into the Product Designer 5 software A - Locate the chart on your Excel spreadsheet.     1 - Remove all $ signs, inch marks (“), and commas.     2 - ...
    • Updating customer information, many customers at once

      Summary Using the SWCS 4.2 Export Utility, Microsoft Excel and the SWCS 4.2 Import Utility, update information such as active status, shipping method, etc. for many customers at once. More Information The Solatech Window Covering Software allows you ...
    • How to Set Up Item Price Adjustments in SalesPRO

      Summary This article describes how to set up Item Price Adjustments in SalesPRO.  Item price adjustments allow you to add an additional amount to the Retail price shown on your quotes and orders.  This additional amount will not be seen by the ...
    • How to enter a new base retail price in order entry

      Summary SalesPRO software gives you the ability to enter a base retail price of your choice in Order Entry for any product in the software.  This is especially helpful when using Customer (CUS) products that do not have any pricing by design.  By ...
    • How to Retain Options when Selecting a New Product and/or Style in Detailed Price Compare

      Information This article describes how to use a new check box in Detailed Price Compare  "Replace options on Existing Line Items". More Information Notes You must be running SWCS 4.2 version or higher You must have installed Hot Fix 333587 ...