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

[Cris with no H]

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?

[TKA]

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

[Cris with no H]

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

[Hans-Olav]

Hi Cris

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

[Cris with no H]

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

[Niccinator]

Coming back around to this Feb 2026. Any solutions?
 

[Jörg Schuchardt]

Hello Niccinator,

 

have you tried with roundup?
lets say cell B2 has 43,2
in a new cell use the syntax
=ROUNDUP(B2; 0)
it will return 44

Best
Jörg

[Niccinator]

Hi Jörg, 

Thanks for your response.  This approach doesn't work when you use it in a worksheet where items are summarized and then summed.  I need the total length to be added, and then that amount needs to be rounded to the nearest inch.  When you use roundup, I suspect that it rounds each individual item in that row separately, then adds them up together, which makes a huge difference if you have lots of little lengths. 

I've found that the following formula will get me accurate counts:

=((CEILING('Soft Goods'.'CurtHeight'*12))/12)

This will give you total curtain length, rounded to the nearest inch.  If you put this in D3, You can then have the next cell over be:

=(VALUE(TXT(D3, '0', 'Millimeters'))) 

to convert to mm. 

Hope this helps some folks out there! @Cris with no H?  I bet you could wrap this in roundup to get to the closest foot.  I haven't tried this though. 

Cheers, 

Nic

Edited April 8 by Niccinator