Thread: Feet and Inches
View Single Post
  #3   Report Post  
Old May 18th 09, 08:39 AM posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default 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.