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.