View Single Post
  #2   Report Post  
Paul Sheppard
 
Posts: n/a
Default


epout Wrote:
How can I multiply 7feet and 6ft 8in using Excel?

I have 7' in A1 column, 6' 8" in B1 column.
When I did =a1 * b1, I get #VALUE! I stretched the column wider
hoping the #VALUE! will disappear and figure comes out. NOPE. Why?

Please help the beginner.


Hi epout

take a look at this earlier thread, may help

http://www.excelforum.com/showthread...highlight=feet

and this link

http://www.cpearson.com/excel/fractional.htm


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=444810