Thread: Feet and Inches
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
HelpExcel.com[_2_] HelpExcel.com[_2_] is offline
external usenet poster
  
Posts: 39
Default Feet and Inches
Tom,

You can convert inches to feet/inches with the following formula:

=INT(F18/12) & "' " & MOD(F18,12) & """"
--
Regards,
Eddie
http://www.HelpExcel.com


"HighJumpTom" wrote:

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.
Reply With QuoteReply With Quote