Is there a custom format that will show everything in the cell except the end
(last two) zeros.

For example, I want 478900 to show in the formula bar, but I want the cell
to show 4789 (no rounding). And I want 98000 to show in the formula bar, but
want 9800 to show in the cell. In other words, I don't want the last two
zeros to show.

Anyone know if that's possible?