Posted to microsoft.public.excel.worksheet.functions

Brett Romero

Posts: n/a

How to show zero for #DIV/0!

Is there a way to replace #DIV/0! with a zero?

Thanks,
Brett

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
How do I show break in bar graph to show large and small numbers	GK	Charts and Charting in Excel	1	December 19th 05 08:23 PM
Line Chart - show percent and value?	PK	Charts and Charting in Excel	5	November 18th 05 04:24 PM
Show values from other sheet	TONY	Excel Worksheet Functions	0	August 31st 05 03:03 PM
UDF and Calculation tree	Ken Wright	Links and Linking in Excel	1	February 6th 05 04:58 PM
Show a date based on today	DJ Dusty	Excel Worksheet Functions	2	November 12th 04 03:20 AM

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

About Us

"It's about Microsoft Excel"