Posted to microsoft.public.excel.misc

JSN

external usenet poster

Posts: 1

How do I hide the #DIV0! statement in a cell?

Trying to make a spreadsheet more presentable by removing the #DIV0!
statements which result in formulas with 0 or no values.

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
#VALUE & #DIV0	tonyalt3	Excel Worksheet Functions	2	January 9th 08 01:46 PM
Is there a way of not displaying 'Div0!' in a cell?	Rani	Excel Discussion (Misc queries)	4	August 7th 07 08:50 AM
IRR & #DIV0!	David	Excel Worksheet Functions	4	January 23rd 07 05:13 PM
I WANT TO HIDE THIS #DIV0!	HERNAN	Excel Discussion (Misc queries)	9	July 26th 06 07:28 PM
Hide Row command using if statement	DME	Excel Worksheet Functions	2	February 16th 05 03:44 PM

All times are GMT +1. The time now is 07:22 PM.

About Us

"It's about Microsoft Excel"