That worked but now how do I make 69 show as 5'9" instead of 5.75
--
Thanks
Cyber Gardener


"Jim Thomlinson" wrote:

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