This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
as an ex. (33.25) = (33'4")
as an ex. (12.47) = (12'1/2")
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
I don't know how .25 should give 4", or how .47 should give 1/2", but if you have those numbers in column A, starting with A1, then you could put this formula in B1:
=INT(A1)&"'"&TEXT(MOD(A1,1)*12,"0")&CHAR(34)
and copy it down. These are the results that I got:
| 33.25 | 33'3" | |
|---|---|---|
| 12.47 | 12'6" |
Hope this helps.
Pete
Answer accepted by question author
I wouldn't actually do it this way, but here is another method that also works...
=SUBSTITUTE(TEXT(100*INT(A1)+12*MOD(A1,1),"0' 00""")," 0"," ")
as well as this method...
=SUBSTITUTE(SUBSTITUTE("X' Z""","X",INT(A1)),"Z",ROUND(12*MOD(A1,1),0))
Answer accepted by question author
(Same questions at Pete_UK)
Here's another approach:
=INT(A1)&"' "&MOD(MROUND(A1,1/12),1)*12&""""
Answer accepted by question author
Your shown conversions are not correct. This formula will do what you want and show the correct conversions for you...
=TEXT(A1,"0' ")&TEXT(MOD(A1,1)*12,"0""")