Adding number within a cell
 

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.

Adding number within a cell
 

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)

"Jon A" wrote in message
...
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.

Adding number within a cell
 

Toolsoptionstransition and select transition formula entry,
note that dates will be calculated as division


--


Regards,


Peo Sjoblom


"Jon A" wrote in message
...
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.

Adding number within a cell
 

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

"Ron Coderre" wrote:

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)

"Jon A" wrote in message
...
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.

Adding number within a cell
 

Incredible how fast you knew and replied...and solved my problem!
Thank you!!!


"Peo Sjoblom" wrote:

Toolsoptionstransition and select transition formula entry,
note that dates will be calculated as division


--


Regards,


Peo Sjoblom


"Jon A" wrote in message
...
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.

Adding number within a cell
 

Just notice that a date like 2/4/2008 will be calculated


--


Regards,


Peo Sjoblom


"Jon A" wrote in message
...
Simple, if you're brilliant!
Thank You!!!

"Ron Coderre" wrote:

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)

"Jon A" wrote in message
...
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.