stop rounding in cell
 

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?

stop rounding in cell
 

Hi

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


Regards

Roger Govier


Lady112017 wrote:
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?

stop rounding in cell
 

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

stop rounding in cell
 

On Wed, 7 Dec 2005 08:17:02 -0800, "Lady112017"
wrote:

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?

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