Round number to the thousands without changing underlying number

T

Tim Caldwell

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.
 
J

JE McGimpsey

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.
 
Top