How can I show Feet and inches in a Excel cell?
How can I show Feet and inches in a Excel cell?
I'd like to calculate Feet and inches in a Excel sheet |
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 "Magama13" wrote: How can I show Feet and inches in a Excel cell? I'd like to calculate Feet and inches in a Excel sheet |
All times are GMT +1. The time now is 04:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com