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?

Hi Mille,

try to format the cell as ###."0"

does this helps?
Regards from Brazil
Marcelo


"Millie" escreveu:

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?

That does work, but it rounds the number so that 478900 becomes 4790. I want
it to show as 4789 and not round it to a higher number.

Thanks.

"Marcelo" wrote:

Hi Mille,

try to format the cell as ###."0"

does this helps?
Regards from Brazil
Marcelo


"Millie" escreveu:

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?