ExcelBanter - convert decimal to inch & fraction

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

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

- - convert decimal to inch & fraction (https://www.excelbanter.com/excel-discussion-misc-queries/62531-convert-decimal-inch-fraction.html)

davepatrob

convert decimal to inch & fraction

CAN YOU FORMAT A CELL TO CONVERT DECIMALS TO INCH & FRACTION OF INCH?

Biff

convert decimal to inch & fraction

Hi!

How small a fraction? To 1/64? 1/128?

Goto FormatCellsNumber tabFraction

From the Type drop down select either:

Up to 2 digits
Up to 3 digits

Biff

"davepatrob" wrote in message
...
CAN YOU FORMAT A CELL TO CONVERT DECIMALS TO INCH & FRACTION OF INCH?

All times are GMT +1. The time now is 07:27 PM.