can't add
 

All: I have been using Excel 2003 for years and indeed just completed a
spreadsheet with lots of totals. In the current(and different) spreadsheet,
when I use the SUM symbol, the results in the cell are only the formula.
Normally, after that I click the "check" symbol to complete the process which
now still leaves only the formula.
Please and thanks for any advice and counsel.
--
Thanks, Ajimmo

can't add
 

It sounds like either:
1) You have the cell formatted as Text
To fix: <format<cells<number tab....Category: (pick appropriate)

or (less likely)...
2) You have Formula Display turned on.
To fix: <tools<options<view....UNcheck: Formulas

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"ajimmo" wrote in message
...
All: I have been using Excel 2003 for years and indeed just completed a
spreadsheet with lots of totals. In the current(and different)
spreadsheet,
when I use the SUM symbol, the results in the cell are only the formula.
Normally, after that I click the "check" symbol to complete the process
which
now still leaves only the formula.
Please and thanks for any advice and counsel.
--
Thanks, Ajimmo

can't add
 

-- Ron: Many thanks. I used both processes and the trouble cleared. I
believe I may have once known this but the brain maxes out from time to time.
Thanks again, Ajimmo
How can I rate the post?

"Ron Coderre" wrote:

It sounds like either:
1) You have the cell formatted as Text
To fix: <format<cells<number tab....Category: (pick appropriate)

or (less likely)...
2) You have Formula Display turned on.
To fix: <tools<options<view....UNcheck: Formulas

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"ajimmo" wrote in message
...
All: I have been using Excel 2003 for years and indeed just completed a
spreadsheet with lots of totals. In the current(and different)
spreadsheet,
when I use the SUM symbol, the results in the cell are only the formula.
Normally, after that I click the "check" symbol to complete the process
which
now still leaves only the formula.
Please and thanks for any advice and counsel.
--
Thanks, Ajimmo

can't add
 

You're welcome.....I'm glad I could help.

Rating is only available if you access the Excel groups via the web
interface:
http://www.microsoft.com/office/comm...&lang=en&cr=US

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

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"ajimmo" wrote in message
...

-- Ron: Many thanks. I used both processes and the trouble cleared. I
believe I may have once known this but the brain maxes out from time to
time.
Thanks again, Ajimmo
How can I rate the post?

"Ron Coderre" wrote:

It sounds like either:
1) You have the cell formatted as Text
To fix: <format<cells<number tab....Category: (pick appropriate)

or (less likely)...
2) You have Formula Display turned on.
To fix: <tools<options<view....UNcheck: Formulas

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)


"ajimmo" wrote in message
...
All: I have been using Excel 2003 for years and indeed just completed
a
spreadsheet with lots of totals. In the current(and different)
spreadsheet,
when I use the SUM symbol, the results in the cell are only the
formula.
Normally, after that I click the "check" symbol to complete the process
which
now still leaves only the formula.
Please and thanks for any advice and counsel.
--
Thanks, Ajimmo