What you have is correct... Just make sure you ahve installed the Analysis
Toolpack Addin... Tools - Addins - Analysis Toolpack (check)
--
HTH...

Jim Thomlinson


"cybergardener" wrote:

How can I convert inches to feet, I have tried =CONVERT(A2,"in","ft")
--
Thanks
Cyber Gardener