Round number to the thousands without changing underlying number
 

I have a number in a cell, for example 1,234,567. I want this number to
display as 1,234,000. but I do not want the number in the cell to change. I
do not know how to do this with the format cells function. Does anyone have
any idea how to make this happen. The ROUND function changes the underlying
data. That will not work for me.

Round number to the thousands without changing underlying number
 

One way:

Format/Cells/Number/Custom #,##0,",000"

NOTE: This actually shows a rounded number (as you have in your subject
line) rather than a truncated number (as you showed in your example) -
e.g., 1,234,567 will display as 1,235,000, not 1,234,000.


In article ,
Tim Caldwell <Tim wrote:

I have a number in a cell, for example 1,234,567. I want this number to
display as 1,234,000. but I do not want the number in the cell to change. I
do not know how to do this with the format cells function. Does anyone have
any idea how to make this happen. The ROUND function changes the underlying
data. That will not work for me.

Round number to the thousands without changing underlying number
 

=INT(A1/1000)


"Tim Caldwell" wrote:

I have a number in a cell, for example 1,234,567. I want this number to
display as 1,234,000. but I do not want the number in the cell to change. I
do not know how to do this with the format cells function. Does anyone have
any idea how to make this happen. The ROUND function changes the underlying
data. That will not work for me.

Round number to the thousands without changing underlying numb
 

Correction:

=ROUND(A1,-3)


"Teethless mama" wrote:

=INT(A1/1000)


"Tim Caldwell" wrote:

I have a number in a cell, for example 1,234,567. I want this number to
display as 1,234,000. but I do not want the number in the cell to change. I
do not know how to do this with the format cells function. Does anyone have
any idea how to make this happen. The ROUND function changes the underlying
data. That will not work for me.