LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Cell displays #'s incorrectly

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula displays in cell Richard Ward Excel Discussion (Misc queries) 2 August 31st 07 10:16 PM
Calendar Control 9.0 displays incorrectly on other machines tmirelle Excel Discussion (Misc queries) 3 January 31st 07 09:43 PM
Cell Formatting Incorrectly Displayed MINI_Micia Excel Discussion (Misc queries) 2 November 13th 06 06:05 PM
date in Excel displays incorrectly when merged in letter Feather 52 Excel Discussion (Misc queries) 1 March 13th 06 10:36 PM
Formula window displays correct answer while cell displays incorre MMV Excel Worksheet Functions 3 November 10th 04 09:28 PM


All times are GMT +1. The time now is 03:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"