Adding number within a cell

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.
 
R

Ron Coderre

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)
 
P

Peo Sjoblom

Tools>options>transition and select transition formula entry,
note that dates will be calculated as division


--


Regards,


Peo Sjoblom
 
J

Jon A

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...
 
P

Peo Sjoblom

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
Automatic adding in a single cell w/o equal sign 9
Making an excel sheet so formulas can not be deleted in the sum to 2
Simple Addition Function 3
find and replace numeric strings in larger text strings 8
Find numbers in a range that sum up to a specified number 6
Excel Need Countifs Formula Help 0
Can I use an "=" in Excel 2007 cell without making it a function? 2

Top