Decimal Values

J

JimQ

For some reason I can not get decimal values to show up on my spread sheet.
For instance, if my A1 Value is 2050, I type in Quotient (A1,12), it will
read $170.00. I have it set to currency, I've tried checking and unchecking
precision as displayed. I've tried making the cell huge to accomodate for any
potential smooshing, I've tried adding dozens of extra decimal places, and it
never calculates the change. I tried changing it to accounting too, and it
still doesn't work. What am I doing wrong?
 
T

T. Valko

There won't be any decimal returned. Quotient returns the integer portion of
the division. This will do the same thing as long as the numbers being
divided are always positive.

=INT(A1/12)
 
Top