Feet and Inches
Perhaps, Eddie, you could explain how to use the result of that as the Y
axis value in a chart, which is what the OP was asking?
--
David Biddulph
HelpExcel.com wrote:
Tom,
You can convert inches to feet/inches with the following formula:
=INT(F18/12) & "' " & MOD(F18,12) & """"
I am trying to make a chart using feet and inches on the y-axis. I
know that I could convert to just inches, but I'd really rather not
if it can be avoided. I'm using Microsoft Excel 2008 for Mac version
12.1.5.
|