Custom Number Format

M

Millie

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?
 
M

Marcelo

Hi Mille,

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

does this helps?
Regards from Brazil
Marcelo


"Millie" escreveu:
 
M

Millie

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