| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Why does formula show rather than results (not in text format)
I'm using the sum function to add 6 numbers in excel. In one particular
target cell, it refuses to print the answer; instead it prints the formula. I have made sure that each of the 6 numbers and the target cell are formatted "number", not "text". |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why does formula show rather than results (not in text format)
You might have the sheet set to manual calculation - go to Tools |
Options | Calculation (tab) and ensure that Automatic is ticked. If you want to leave it at manual, you can press F9 to force Excel to recalculate. Hope this helps. Pete |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why does formula show rather than results (not in text format)
Formatting as Number after you entered the formula doesn't help; the cell was formatted as text *before* you entered the formula.
Format as General or Number *and* re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten "Caseybay" wrote in message ... | I'm using the sum function to add 6 numbers in excel. In one particular | target cell, it refuses to print the answer; instead it prints the formula. I | have made sure that each of the 6 numbers and the target cell are formatted | "number", not "text". |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why does formula show rather than results (not in text format)
That was the key! Thanks, Niek!
"Niek Otten" wrote: Formatting as Number after you entered the formula doesn't help; the cell was formatted as text *before* you entered the formula. Format as General or Number *and* re-enter the formula (F2, ENTER) -- Kind regards, Niek Otten "Caseybay" wrote in message ... | I'm using the sum function to add 6 numbers in excel. In one particular | target cell, it refuses to print the answer; instead it prints the formula. I | have made sure that each of the 6 numbers and the target cell are formatted | "number", not "text". |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Why does formula show rather than results (not in text format)
Simply changing the cell formatting isn't enough. If its just one cell,
click it, click in the formula bar and hit F2. For lots of cells, enter '1' in a convenient empty cell, copy it, highlight the offending cells and paste special, multiply, OK, Regards, Alan. "Caseybay" wrote in message ... I'm using the sum function to add 6 numbers in excel. In one particular target cell, it refuses to print the answer; instead it prints the formula. I have made sure that each of the 6 numbers and the target cell are formatted "number", not "text". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Show format in formula bar | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Hybrid Mode
