I have a spreadsheet with outputs in inches; no expected output will be longer than a few inches at most. An example value would be 0.272 inches. This is a little more than a quarter of an inch.
What formula can I use to convert decimal inches to traditional inches display? How can I have it express it in 1/16 of an inch?
Thank you!
Try
Format Cells==>Fraction==> select your requirement
=mround(a1, 1/16) and format as # ??/??
Entia non sunt multiplicanda sine necessitate
Try htis. Format the cells as:
# ??/16
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
That formats 3.25 as 3 4/16, which is not too traditional, Glenn.Originally Posted by Glenn Kennedy
Yes, I just spotted that!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks