G
Guest
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?
(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?