Thread: Force Cell Contents

Is there a way that no matter what is typed in a cell, it always converts to a value of 1? I know this can be done with VBA, and I know how to do it that way, but I can't use VBA in this case. Any ideas?

John Vickers

Not possible without VBA, if there were a few set alternatives you could use
autocorrect but since you say anything it won't work. You could use
data>validation to force someone to type 1

--
Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"John Vickers" <John.Vickers.23cwon_1140151208.0309@excelforum-nospam.com>
wrote in message
news:John.Vickers.23cwon_1140151208.0309@excelforum-nospam.com...
>
> Is there a way that no matter what is typed in a cell, it always
> converts to a value of 1? I know this can be done with VBA, and I know
> how to do it that way, but I can't use VBA in this case. Any ideas?
>
> John Vickers
>
>
> --
> John Vickers
> ------------------------------------------------------------------------
> John Vickers's Profile:
> http://www.excelforum.com/member.php...o&userid=31551
> View this thread: http://www.excelforum.com/showthread...hreadid=513497
>