Or =(100*30*1)*CONVERT(1,"ft","yd")^3
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email
"John C" <johnc@stateofdenial wrote in message
...
Here's a much more difficult way:
=CONVERT(CONVERT(CONVERT(100*30*1,"ft","yd"),"ft", "yd"),"ft","yd")
--
** John C **
"tomtom" wrote:
how do i find the volume of a 100'*30'*1' footing in cubic yards?