Metric Quantities not Displaying Correctly

On-Screen Takeoff uses Window's Regional Settings to format quantity results and was designed to use the English (United States) Regional and Language Options located within Microsoft Windows®.

 

If your quantities are not displaying correctly on the Conditions windows, Condition Properties, Takeoff tab or Worksheet tab, check your Regional Settings to ensure they are set to English (US).

 

 

For example, one problem this can cause is the inability to assign a Height to a condition:

 

In the Condition Properties window a Height of 1000 (mm) is entered but will not display correctly (the number is being stored in the database correctly, it only displays incorrectly in the dialog box).

 

Height set to 1000 (all Metric entries are in millimeters)

 

Height automatically changes to 1 - this is because 1 000 is stored versus 1,000 (the space causes the zeroes to be dropped)

 

To resolve this issue, the Regional and Language Options will need to be modified or set to English(US).

 

1. In the Windows Control Panel double-click the Regional Settings or Region and Language Options icon

    

   

    

2. Now, you can either select English (United States) as in the example below

    

   
   Click to Enlarge

    

3. OR, you can modify the settings for your language of choice
4. In the Regional and Language Options window notice that the Number: sequence shows digits separated by spaces

    

   
   Click to Enlarge

    

5. Click the Customize this format... button (in Windows XP click the Customize button)
6. Notice, in the Customize Regional Options the Digit grouping symbol is a space (you can see the example under Digit grouping: notice how the number is formatted 123 456 789 - those spaces will cause issues with On-Screen Takeoff)

    

   
   Click to Enlarge

    

7. Change the Digit grouping symbol: to a comma (,) now, you'll see that the Digit Group example will be formatted 123,456,789 - now that there is no space in the string it will be displayed correctly.

    

   
   Click to Enlarge

    

8. Click the OK button, then click OK again to exit the Regional and Language Options window

 

 

 Back to FAQs