| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help. Excel shows formulas, not answers
I have copied a spreadsheet. One spreadsheet works the way I want. The
copied spreadsheet (modified to fit another account) show formulas and not answers, |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help. Excel shows formulas, not answers
Check to see if you have your formula view on: Click ToolsOptions, select
the View tab and uncheck the "Formulas" check box if it's checked. "Klodney" wrote: I have copied a spreadsheet. One spreadsheet works the way I want. The copied spreadsheet (modified to fit another account) show formulas and not answers, |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
help. Excel shows formulas, not answers
You were exactly correct. Formulas was checked under ToolsOptions. When I
unchecked it, things seem to work as I had intended. Thank you ever-so-much. "Paul Mathews" wrote: Check to see if you have your formula view on: Click ToolsOptions, select the View tab and uncheck the "Formulas" check box if it's checked. "Klodney" wrote: I have copied a spreadsheet. One spreadsheet works the way I want. The copied spreadsheet (modified to fit another account) show formulas and not answers, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel shows formula, not result | Excel Discussion (Misc queries) | |||
| scalable headings in Microsoft Excel when editing long formulas | Excel Discussion (Misc queries) | |||
| Putting Excel formatting and/or formulas into CSV file | Excel Discussion (Misc queries) | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| How Excel & ACCPAC 6.1 calculate formulas???? | Excel Worksheet Functions | |||
Linear Mode
