stop rounding in cell

L

Lady112017

i want the numbers in my cells to show as they are without being rounded but
to show in thousands. I want to maintain integrity. Eg. 97,654 should just
show as 97. i don't want it to round up or down. is this possible?
 
R

Roger Govier

Hi

Try
=INT(A1/1000)
but note anything less than 1000 will show as 0.


Regards

Roger Govier
 
D

Dave O

Try this formula:
=INT(A1/1000)
.... where A1 contains 97,654. This formula returns only the integer
value of the "divide by 1000" math.
 
R

Ron Rosenfeld

i want the numbers in my cells to show as they are without being rounded but
to show in thousands. I want to maintain integrity. Eg. 97,654 should just
show as 97. i don't want it to round up or down. is this possible?
Click to expand...

I don't think it is without changing the contents of the cell.

You could custom format it but then your number would show as 98, although
could still contain 97,654.


--ron
 
Top