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