View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How can I add whole numbers to fractions?

I generally enter such measurements in the form 2 4/12 (I format the range
with custom format # ??/12 to prevent Excel making this 2 1/3)
Such values can be mathematically manipulated (summed, averaged, etc)

For a alternatives see
http://www.cpearson.com/excel/fractional.htm
http://www.cpearson.com/excel/FeetInches.htm

best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"aw" wrote in message
...
I am trying to produce a chart that will add up FT-IN, is this possible
with
Excel?