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 -- 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 |
Force Cell Contents
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 datavalidation to force someone to type 1 -- Regards, Peo Sjoblom Northwest Excel Solutions Portland, Oregon "John Vickers" wrote in message news:John.Vickers.23cwon_1140151208.0309@excelforu m-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 |
All times are GMT +1. The time now is 05:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com