The decimal point need some space. So I can have 12 display OK but 1.1
displays # when I make the cell very narrow.
Not much one can do (from cool Nova Scotia ---- 'cool' as in low °C)
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"PJ in Fla" wrote in message
...
In Excel 2003, I have cells formatted to display with 0 decimal places.
The
formula in the cell evaluates to a number with many decimals (=10/9), and
displays correctly (1) unless the width is less than 60 pixels. Then it
fills the cell with #'s.

In the font I'm using, the cell should display correctly down to 12
pixels.
Other cells that evaluate to whole numbers display correctly.

I'd prefer not to have to have cells wide enough to display all the
fractional numbers if I only want 0 decimals. Is there a solution or is
this
just "one of those Excel things"?


--
---------------------------
PJ in (stormy) Fla