John,

You will know best, but are you sure that that is what you want? You will
end up with 10,000 in the cell and no trail to tell you how that figure was
arrived at. Would you not be better to use more than one cell so that the
result will be more meaningful.

--
Regards


Sandy

Replace@mailinator with @tiscali.co.uk


"John Britto" wrote in message
...
Hi,
Yes, you are correct. Though I don't know VBA. Please explain me how to
accomplish my request. Suppose a container holds 2000 cartons and 5
containers equal how much. So, when i enter 5 the result will be 10,000..
Just out of curiosity I am looking for this..

Thanks..john britto

"AlfD" wrote:


Hi!

But you can if you use VBA.

Is this what you want?

Example: A1 holds 1000.
You click on A1 and enter 2
A1 now shows 2000

Alf


--
AlfD
------------------------------------------------------------------------
AlfD's Profile:
http://www.excelforum.com/member.php...fo&userid=4785
View this thread:
http://www.excelforum.com/showthread...hreadid=474318