Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|