G Guest Jan 28, 2005 #1 How can I show Feet and inches in a Excel cell? I'd like to calculate Feet and inches in a Excel sheet
How can I show Feet and inches in a Excel cell? I'd like to calculate Feet and inches in a Excel sheet
G Guest Jan 28, 2005 #2 Excel is metric like all sensible people or things <bg>, but I would put feet and inches in separate but adjacent cells, then you have to convert them to decimale and do the calculation and then convert them back again http://www.mvps.org/dmcritchie/excel/fractex1.htm Regards, Peo Sjoblom
Excel is metric like all sensible people or things <bg>, but I would put feet and inches in separate but adjacent cells, then you have to convert them to decimale and do the calculation and then convert them back again http://www.mvps.org/dmcritchie/excel/fractex1.htm Regards, Peo Sjoblom
