Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula displays in cell | Excel Discussion (Misc queries) | |||
Calendar Control 9.0 displays incorrectly on other machines | Excel Discussion (Misc queries) | |||
Cell Formatting Incorrectly Displayed | Excel Discussion (Misc queries) | |||
date in Excel displays incorrectly when merged in letter | Excel Discussion (Misc queries) | |||
Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions |