G
Guest
Need help getting decimal fractions to display without rounding. Example: 21.25/32. The # ??/32 custom format does not work. Any thoughts?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
I need to clarify upon reflection. I want to enter a number like 99 +21.25/32 and have it display in one cell just like that (the + could go away) and be able to use it in a calculation in others.
A
AlfD
Hi!
I thought I saw a decimal point (period) between the 21 and the 25. Tr
21 25/32 (no period). Looks like this in the cell and looks lik
21.78125 in the formula bar. That help?
Al
I thought I saw a decimal point (period) between the 21 and the 25. Tr
21 25/32 (no period). Looks like this in the cell and looks lik
21.78125 in the formula bar. That help?
Al
A
AlfD
Hi!
Just a postscript.
I use Excel 2000.
Format 3 cells (A1,A2,A3) using the fractions format "up to 2 digits".
Put 24/32 in A1.
Put 5/32 in A2.
Put =A1-A2 in A3.
My result is 19/32.
But I suspect that it is important to format the cells before puttin
the data in them, not after. Could that be?
Al
Just a postscript.
I use Excel 2000.
Format 3 cells (A1,A2,A3) using the fractions format "up to 2 digits".
Put 24/32 in A1.
Put 5/32 in A2.
Put =A1-A2 in A3.
My result is 19/32.
But I suspect that it is important to format the cells before puttin
the data in them, not after. Could that be?
Al
J
Jordon
Format 3 cells (A1,A2,A3) using the fractions format "up to 2 digits".
Put 24/32 in A1.
Put 5/32 in A2.
Put =A1-A2 in A3.
My result is 19/32.
But I suspect that it is important to format the cells before putting
the data in them, not after. Could that be?
I had no problem doing that. It's just that I had
to extract the number 19 from 19/32 to be able
to get a cost per 32nd of an inch.
Thanks though.
Jordon
D
Dana DeLouis
If both fractional numbers are less than 1, then perhaps another option:
=100*DOLLARFR(A1-B1,32)
Another similar way to Jason's:
=LEFT(TEXT(A1,"00/32"),2)-LEFT(TEXT(B1,"00/32"),2)
=100*DOLLARFR(A1-B1,32)
Another similar way to Jason's:
=LEFT(TEXT(A1,"00/32"),2)-LEFT(TEXT(B1,"00/32"),2)
A
AlfD
Hi!
The easiest way to extract 19 from 19/32 is to multiply it by 32.
Works for xx/32.
Just amounts to a change of measuring system from inches to
thirty-seconds, really.
Alf
The easiest way to extract 19 from 19/32 is to multiply it by 32.
Works for xx/32.
Just amounts to a change of measuring system from inches to
thirty-seconds, really.
Alf
J
Jordon
The easiest way to extract 19 from 19/32 is to multiply
it by 32.
Now there's the difference between someone that knows
how math works and someone that's good at writing
formulas.
I really like the KISS principle.
Thank you for that AlfD!
Jordon
A
AlfD
Hi Jordon!
You call it the KISS principle. I guess that might be what I refer t
as Occam's Razor.
Al
You call it the KISS principle. I guess that might be what I refer t
as Occam's Razor.
Al
J
Jordon
You call it the KISS principle. I guess that might
be what I refer to as Occam's Razor.
Occam's Razor assumes that the simplest answer
is the correct one. The Keep It Simple Stupid
principle can have lots of correct answers but
the best answer is the simplest.
Jordon