Kathrine J Wathne

Posts: n/a

Excel - hide erroer values

Hi!
I have an Excel sheet were I have a few formulas. When the sheet is empty of
numbers the formula return the value #DIV/O!

I would like to know how I can hide this text - it does not look neat. I
want the formula to be there; but to show as empty. I have tried to use
conditional formatting which does hide the formula - but it then also hides
the result when I actually put numbers into the sheet.

Kathrine, Norway

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ???	Richard	Excel Discussion (Misc queries)	2	May 13th 23 11:46 AM
Missing values in Excel Line Chart	mw55309	Charts and Charting in Excel	1	January 19th 05 12:10 PM
Formula for Searching & matching two values in excel	Chris	Excel Discussion (Misc queries)	1	January 7th 05 04:34 PM
display negative values as a blank cell in Excel	pherozeb	Excel Discussion (Misc queries)	3	January 5th 05 04:40 AM
display negative values as a blank cell in Excel	Pheroze Bharucha	Excel Discussion (Misc queries)	0	January 4th 05 10:51 PM

All times are GMT +1. The time now is 01:17 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us