This is rather an old thread but drdjones' recent reply brought it to my attention. Prex's formula employing f=0.5 and mgp's function apply to (what I call) 2:1Semi-E's.
A horizontally constructed 2:1SE with no contained flat ended cylinder contains half the volume of a sphere of the same...
Hi bn, this was answered in thread 770-34406 but, if you are like me, and don't know how to search for threads then:-
Format-Cells-Custom ##0.0E+0 OK? - - bjt
Hi z,
I, personally, would use a Command Button macro but you could also do it manually to:
Set text colour to background colour in selected cell/s
Print sheet
Set text colour back to visible.
I think that should work! - - - bjt.