Adding number within a cell

  • Thread starter Thread starter Jon A
  • Start date Start date
J

Jon A

How can I add numbers within a cell without entering the "equal sign" first?
I used to be able to do this. This is a problem in Excel 2007 and 2003.
 
It sounds like you previously had Excel set up to behave like Lotus 1-2-3 :\

If that's what you really want....try this:
From the Excel 2003 Main Menu:
<tools><options><transition tab>
Check: Transition formula entry

Does that help?

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Tools>options>transition and select transition formula entry,
note that dates will be calculated as division


--


Regards,


Peo Sjoblom
 
Simple, if you're brilliant!
Thank You!!!

Ron Coderre said:
It sounds like you previously had Excel set up to behave like Lotus 1-2-3 :\

If that's what you really want....try this:
From the Excel 2003 Main Menu:
<tools><options><transition tab>
Check: Transition formula entry

Does that help?

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
Click to expand...
 
Just notice that a date like 2/4/2008 will be calculated


--


Regards,


Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add (sum) numbers within cells 7
Red cell for negative numbers in Excel 1
Count range of cells if not next to each other 0
Formating a cell in Excell 3
Excel Need Countifs Formula Help 0
Finding most recently entered number within a column 3
Macro for Varying Number of Rows 0
Learning arrays. 13

Back
Top