| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell contents as the 'lookup value' parameter in HLOOKUP function | Excel Discussion (Misc queries) | |||
| Conversion of Cell Contents into a Functional Worksheet name ? | Excel Worksheet Functions | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| cell contents | Excel Discussion (Misc queries) | |||
| Display actual contents of cell | Excel Discussion (Misc queries) | |||
Linear Mode
