Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula numeric input
Is there any way to have Excel assume, as it should, that a number input in a formula means a value? For example, is there a way to change the default so that instead of inputting "+7+8" to calculate 15, that I could just input "7+8". Lotus used to work this way, and I have to believe that Excel would allow the same capability. -- seamaml ------------------------------------------------------------------------ seamaml's Profile: http://www.excelforum.com/member.php...o&userid=30296 View this thread: http://www.excelforum.com/showthread...hreadid=499622 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula numeric input
Toolsoptionstransition and select transition formula entry
-- Regards, Peo Sjoblom Portland, Oregon (No private emails please) "seamaml" wrote in message ... Is there any way to have Excel assume, as it should, that a number input in a formula means a value? For example, is there a way to change the default so that instead of inputting "+7+8" to calculate 15, that I could just input "7+8". Lotus used to work this way, and I have to believe that Excel would allow the same capability. -- seamaml ------------------------------------------------------------------------ seamaml's Profile: http://www.excelforum.com/member.php...o&userid=30296 View this thread: http://www.excelforum.com/showthread...hreadid=499622 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
How to specify numeric format in formula? | Excel Discussion (Misc queries) | |||
Match Each Numeric occurrence and Return Individual Rows of Data | Excel Worksheet Functions | |||
input box = formula bar | Excel Discussion (Misc queries) | |||
How do I view the actual numeric value of a formula in Excel 2002. | Excel Worksheet Functions |