Too Many Decimal Places In Formula

Even more odd...

="Gross: "&ROUND(O82/O86,2) returns 1 decimal place;
="Gross: "&ROUND(O82/O86,3) returns 1 decimal place;
="Gross: "&ROUND(O82/O86,4) returns 4 decimal places;
="Gross: "&ROUND(O82/O86,5) returns 5 decimal places;
="Gross: "&ROUND(O82/O86,6) returns 6 decimal places;
="Gross: "&ROUND(O82/O86,7) returns 7 decimal places; etc...

Rick,

The 2nd option I posted above will not round, but it will always show 2 decimal places.

If you want to round it to 2 decimal places, then you can incorporate both functions I used above:

="Gross: "&TEXT(ROUND(O82/O86,2),"0.00")

HTH

Jason

Thanks! That works great.