If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to format numbers as architectural fractions (1/16,1/8,1/4 )
How do I format a number to the 1/16ths, but display the answer as an
architectural fraction? Example: I want to display .25 as 1/4 rather than 4/16, but want to round to 1/16 precision. |
#2
|
|||
|
|||
How to format numbers as architectural fractions (1/16,1/8,1/4 )
Hi Jack,
Simply format the cell (Format|Cells|Number Fraction 'up to 2 digits'). -- Cheers macropod [Microsoft MVP - Word] "Jack W" Jack wrote in message ... How do I format a number to the 1/16ths, but display the answer as an architectural fraction? Example: I want to display .25 as 1/4 rather than 4/16, but want to round to 1/16 precision. |
#3
|
|||
|
|||
How to format numbers as architectural fractions (1/16,1/8,1/4 )
|
#5
|
|||
|
|||
How to format numbers as architectural fractions (1/16,1/8,1/4 )
On Tue, 16 Feb 2010 10:56:44 +1100, "macropod"
wrote: My understanding is that the input value was already in a decimal value equivalent to 16ths (of an inch, presumably), in which case the formatting is sufficient. Obviously, I did not make that assumption. Certainly would make things simpler. --ron |
#6
|
|||
|
|||
Try this
it will display in Feet, inches and fractions:
=CONCATENATE((INT(C9/12)),"'-",INT((C9/12-INT(C9/12))*12+0.001),IF(C9-INT(C9)0,TEXT((C9-INT(C9))," #??/??"),""),"""") C9 is a decimal number that you want converted Jack W wrote: How to format numbers as architectural fractions (1/16,1/8,1/4 ) 15-Feb-10 How do I format a number to the 1/16ths, but display the answer as an architectural fraction? Example: I want to display .25 as 1/4 rather than 4/16, but want to round to 1/16 precision. Previous Posts In This Thread: On Monday, February 15, 2010 11:14 AM Jack W wrote: How to format numbers as architectural fractions (1/16,1/8,1/4 ) How do I format a number to the 1/16ths, but display the answer as an architectural fraction? Example: I want to display .25 as 1/4 rather than 4/16, but want to round to 1/16 precision. On Monday, February 15, 2010 11:28 AM macropod wrote: Hi Jack,Simply format the cell (Format|Cells|Number Fraction 'up to 2 Hi Jack, Simply format the cell (Format|Cells|Number Fraction 'up to 2 digits'). -- Cheers macropod [Microsoft MVP - Word] On Monday, February 15, 2010 12:42 PM Ron Rosenfeld wrote: wrote:You cannot do that just with formatting. wrote: You cannot do that just with formatting. If you merely set the format to display as fraction with up to two digits, which has been suggested, then you will not round to 16ths. You *DO* need to set the format to fraction with up to two digits. But: What is required is either a VBA routine, which will alter your entry "on the fly" to round to 16ths, or set up your worksheet so that the value is entered in one cell; and then in a "helper column" you have a formula to do the rounding: e.g. =ROUND(A1*16,0)/16 --ron On Monday, February 15, 2010 6:56 PM macropod wrote: Hi Ron,My understanding is that the input value was already in a decimal value Hi Ron, My understanding is that the input value was already in a decimal value equivalent to 16ths (of an inch, presumably), in which case the formatting is sufficient. -- Cheers macropod [Microsoft MVP - Word] On Monday, February 15, 2010 7:22 PM Ron Rosenfeld wrote: wrote:Obviously, I did not make that assumption. wrote: Obviously, I did not make that assumption. Certainly would make things simpler. --ron Submitted via EggHeadCafe - Software Developer Portal of Choice Crypto Obfuscator for .NET - Product Review http://www.eggheadcafe.com/tutorials...or-for-ne.aspx |
Thread Tools | |
Display Modes | |
|
|