Cris with no H Posted November 12, 2018 Share Posted November 12, 2018 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? Quote Link to comment
TKA Posted November 13, 2018 Share Posted November 13, 2018 select whatever cells you want then go to format cell and under "number" you can force it to no fractions Quote Link to comment
Cris with no H Posted January 29, 2019 Author Share Posted January 29, 2019 Still being frustrated by this. It might work in regular worksheet cells, but doesn't seem to work for database cells. Quote Link to comment
Hans-Olav Posted January 29, 2019 Share Posted January 29, 2019 Hi Cris You will have to select the whole column and then apply formatting, choose Number and decide how many decimals Quote Link to comment
Cris with no H Posted January 29, 2019 Author Share Posted January 29, 2019 I'm attaching a file showing my problem. Schedule of softgoods. It's the Length I need to round off. I'd like them to round up, but I'll settle for no fractions, at this point. DIMENSION ROUNDING TEST.vwx Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.