LinkBack URL
About LinkBacks
Hello,
Anyone know how to convert decimal inches to fractional inches?
So if I entered a decimal in a cell, it would look like this:
enter display
.75 = 3/4"
1 = 1"
1.25 = 1 1/4"
1.5 = 1 1/2"
Hello,
Anyone know how to convert decimal inches to fractional inches?
So if I entered a decimal in a cell, it would look like this:
enter display
.75 = 3/4"
1 = 1"
1.25 = 1 1/4"
1.5 = 1 1/2"
You can right click on the cell and select "Format"
Then, you can click on "Fraction" in the numbers tab
Then you have a selection for various types
Or you can do something like (applicable for cell A1): =INT(A1)&"' "&TEXT(12*(A1-INT(A1)),"# #/#")&CHAR(34) -- but that converts it to a text and gives you denominators other than multiples of two
<---If my answer helped, please click *
I tried the fraction format, but it will not give me the inches quotation marks.
Just format cells as Custom, #"''" ? /??Originally Posted by Dowjd
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Try the personalized format
# ?/?\"
Go back to the format then go to custom
# ?/?\"
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
ChemistB, that kind of worked. Anything larger than a single digit works great, but if I input 1, 2, 3...etc it displays 1 " instead of 1". The inches quotation are very far out.
Last edited by Dowjd; 01-08-2016 at 02:34 PM.
Dow,
Unless the gurus know something I don't (about this -- they know A LOT), it looks like you'll have to deal with a text by modifying =INT(A1)&"' "&TEXT(12*(A1-INT(A1)),"# #/#")&CHAR(34) as-needed if you absolutely need the quotation mark to be closer
Hey Joe
It still didn't work right. It rounds up. 1.25 should display as 1 1/4", but it comes out 1' 3", but I fixed that. Also 1" comes out 1 0"
Joe's right except I think your formula would be
=IF(MOD(A1,1),IF(INT(A1), INT(A1) & " "&TEXT(MOD(A1,1),"?/?\"""),TEXT(MOD(A1,1),"?/?\""")),IF(INT(A1), INT(A1) & """",""))
So I know there is a custom format, say if I enter:
1, I get 1" custom format (#"''")
or
1.25, I get 1 1/4" custom format (#? ?/?"''")
How would I create a custom format that combines the two formats?
Last edited by Dowjd; 01-08-2016 at 04:24 PM.
Instead of ? (which hold spaces even if the digit is not shown), use #. # #/#\"
One of my most frequently used help files: https://support.office.com/en-au/art...fab54be7f4#bm1 Under "include decimal places and significant digits, it describes the behavior of the 3 place holders -- 0, #, ?
MrShorty. Thanks. That didn't work, but I did get it to work by deleting the period. # # #/#\"
Success
Thanks everyone.
Glad you were able to see past my inadvertent decimal point.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks