Automatically Add a Number to Cell Entry

**BazzaBoy** · 07-20-2010, 04:49 AM

What do I do to add 0.00001 automatically to whatever I enter into a cell. So, if I enter the number 5 into a cell, it should automatically come up as 5.00001.

Is it dependant on cell formatting, or do I use a macro? I would like to avoid macro if possible.

Thanks in advance for any help.

**gilbert** · 07-20-2010, 05:05 AM

The easiest way to do this is maintain 2 cells, the first being key in cell and the second one being the results

eg. In Cell A1 - key in cell (here u will punch in 5); whereas in Cell B1, you preset the formula to =A1+0.00001

Maybe there is a better way of doing it.... but this is the simplest way to do it.

**DonkeyOte** · 07-20-2010, 05:06 AM

This all rather depends on whether or not

a) the underlying value needs to be adjusted for arithmetic or aesthetic purposes

b) whether the value(s) being entered are always whole numbers

If the adjustment is not purely for sake of aesthetics then you will need to use VBA if you wish to alter the underlying value of the entry cell itself.

**BazzaBoy** · 07-21-2010, 09:35 PM

Thanks Guys,

But this is not waht I had in mind.

**DonkeyOte** · 07-22-2010, 01:46 AM

Originally Posted by Bazzaboy

this is not waht I had in mind

I don't recall actually suggesting anything ...

I was asking you detail your requirements more fully - the why's etc... as is it is all a little vague I'm afraid.

As previously stated - if your intention is to affect the physical value in the entry cell then you must use VBA.

**BazzaBoy** · 07-22-2010, 09:34 PM

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.

If VBA is the only way to go, could you please suggest a code? The thing is I have too much going on by the way of VBA in that sheet and don't want to keep increasing the number of code modules.

Would you, like me to start a fresh topic in the VBA section of this forum?

Thanks.

**DonkeyOte** · 07-23-2010, 01:57 AM

Originally Posted by BazzaBoy

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)