Avoiding the zeros

Bob White

Board Regular
Joined
May 4, 2008
Messages
61
I have a complex (for me) spreadsheet that goes pear shaped if a zero is introduced into any one of a set of cells.

Can anyone suggest a way of making a default setting for these cells to be, say 0.0001? This way myspread sheet continues to work. The 0.0001 has a negligable effect on the calcs.
:rolleyes:
 

Paella1

Active Member
Joined
Mar 10, 2005
Messages
382
I suggest it would be more productive to fix the problem that is causing things to go pear-shaped when a zero is encountered. Can you provide some more detail on that?
 

Fazza

MrExcel MVP
Joined
May 17, 2006
Messages
9,201
Hi, Bob.

What if you select the range of cells and do a find and replace (CTRL-H) to change all the zeros to 0.0001 - being sure to select whole cell values only so that entries like 50 don't change?

Or maybe use data validation on the cells so that 0 is not a valid entry?

HTH, Fazza
 

Forum statistics

Threads
1,085,334
Messages
5,383,024
Members
401,812
Latest member
topherj09

Some videos you may like

This Week's Hot Topics

Top