ExcelBanter - formula for converting decimal to inch & fraction

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula for converting decimal to inch & fraction (https://www.excelbanter.com/excel-discussion-misc-queries/62567-formula-converting-decimal-inch-fraction.html)

davepatrob

formula for converting decimal to inch & fraction

Can you provide a formula to convert a decimal to an inch & fraction?
I am using Excel 2000.
Thank you for your help.

Gary''s Student

formula for converting decimal to inch & fraction

select the cell and pull-down:

Format Cells... Fraction and the pick a suitable form.
--
Gary's Student

"davepatrob" wrote:

Can you provide a formula to convert a decimal to an inch & fraction?
I am using Excel 2000.
Thank you for your help.

All times are GMT +1. The time now is 06:57 AM.