Need help with division, please!!!

Can someone please tell me how to create a formula that will allow me to divide a number in half in the same cell of the initial number. In other words, if I type in the number 1000, I want a formula that will convert that same number to 500 as soon as I hit tab, enter, or whatever...
Thanks!!!!

A cell can contain a constant OR a formula. Not both. You will need VBA for
this. But a worksheet has close to 17 million cells, so I believe you can
afford one extra to perform your division.

HTH. Best wishes Harald


"swag143" <[email protected]> skrev i
melding news:[email protected]...
>
> Can someone please tell me how to create a formula that will allow me to
> divide a number in half in the same cell of the initial number. In
> other words, if I type in the number 1000, I want a formula that will
> convert that same number to 500 as soon as I hit tab, enter, or
> whatever...
> Thanks!!!!
>
>
> --
> swag143
> ------------------------------------------------------------------------
> swag143's Profile:
http://www.excelforum.com/member.php...o&userid=37602
> View this thread: http://www.excelforum.com/showthread...hreadid=572236
>