Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a number to a cell that already has a number. | Excel Discussion (Misc queries) | |||
Adding the same number to each cell in a column | New Users to Excel | |||
Adding number to each cell in a column | Excel Discussion (Misc queries) | |||
adding number in next cell | New Users to Excel | |||
adding number only if CDN is displayed in next cell | New Users to Excel |