LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 249
Default How to stop ## showing when cell contents too wide

sI have narrow cells in which i have formulas which return a month name when
certain criteria are matched

When the formulas return a true result, the month name shows, but is too
wide for the narrow cell and displays as ##

Is there a way to make the contents display fully. I dont mind if the cell
answer covers the result from the next cell as there will always be blank
results next to the cell.

Can anyone help?
 
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
Cell contents not showing JulieG Excel Discussion (Misc queries) 3 October 2nd 09 01:31 PM
Stop cell showing zero when returning a blank cell Sapper Excel Discussion (Misc queries) 2 April 26th 09 11:24 PM
How to stop cell showing #VALUE! please RobertSE6 Excel Discussion (Misc queries) 5 October 22nd 07 02:12 PM
Entire contents of cell not showing Marilyn L Excel Worksheet Functions 6 March 5th 06 03:42 PM
showing the contents of a consolidated cell Ken Excel Worksheet Functions 0 January 6th 05 05:47 PM


All times are GMT +1. The time now is 05:59 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"