Decimal Values
 

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?

Decimal Values
 

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)

--
Biff
Microsoft Excel MVP


"JimQ" wrote in message
...
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?