Jump to content
Cris with no H

Is there a way to round off dimensions in a worksheet?

Recommended Posts

Title pretty much asks it all.  I am frustrated by the returned length of softgoods and want to be able to round (up, preferably) so that we order whole units of softgoods.  24 feet, rather than 23 feet 9.5".  The pipe-and-drape object in particular returns lengths that are not the drawn (desired) length, presumably deducting the diameter of the end poles.  So.  For this and many other uses, it would be helpful to have more control over the dimensional readouts in my worksheets.  Advice?

Share this post

Link to post

select whatever cells you want then go to format cell and under "number" you can force it to no fractions

Share this post

Link to post

Still being frustrated by this.  It might work in regular worksheet cells, but doesn't seem to work for database cells.

Share this post

Link to post

Hi Cris

You will have to select the whole column and then apply formatting, choose Number and decide how many decimals 

Share this post

Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114


© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.