Quote Originally Posted by BazzaBoy View Post
Yes, I do wish to affect the physical value in the cell. So, if I enter 0 in the cell it must behave as if I have entered 0.00001 in the cell. All this, because I am having problems with dividing some cell values by 0.
Before getting into the VBA perhaps best to elaborate regards the above ?

If you're looking to avoid #DIV/0! issues elsewhere (ie these are divisor precedents) then validate the value prior to conducting the division, eg:

=IF(SUM(A1),B1/A1,0)

where A1 is the entry cell and B1 stores some other numeric value ... if A1 is 0 the result will be 0 rather than #DIV/0!
(you can adjust the logic as desired)