ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   add one cell with no equals operator (https://www.excelbanter.com/excel-discussion-misc-queries/67053-add-one-cell-no-equals-operator.html)

reggie26t

add one cell with no equals operator
 
How do you add two numbers in a cell without typing the equals operator
first? I have a spreadsheet that allows me to add two numbers without typing
the equals operator first. I cannot replicate it on the new spreadsheet. I
know it works. I just can't get mine to do it

Ron Rosenfeld

add one cell with no equals operator
 
On Tue, 24 Jan 2006 06:30:02 -0800, reggie26t
wrote:

How do you add two numbers in a cell without typing the equals operator
first? I have a spreadsheet that allows me to add two numbers without typing
the equals operator first. I cannot replicate it on the new spreadsheet. I
know it works. I just can't get mine to do it



Select

Tools/Options/Transition Transition Formula Entry

It's a Lotus thing.


--ron


All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com