| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
why does the formula show instead of the result when copying?
I have been using a conditional if statement to copy information from current
workbook to a new workbook. Sometimes not the information but the formula shows up and i can't get rid of it. -- bob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
why does the formula show instead of the result when copying?
"rws" wrote:
I have been using a conditional if statement to copy information from current workbook to a new workbook. Sometimes not the information but the formula shows up and i can't get rid of it. If all cells show formulas, look at the Formulas Windows option under Tools Options View (Excel 2003). Be sure that it is not checkmarked. More like, the individual cell was formatted as text before you entered the formula. Change the cell format to General or another appropriate format by clicking on Format Cells Number. Then press F2 and Enter (or ctrl-shift-Enter for an array formula) in order to re-enter the formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying a formula but only getting the result | Excel Worksheet Functions | |||
| copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
| Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
| Copying result of formula into another worksheet??? | Excel Discussion (Misc queries) | |||
| How do I copy a result without copying the formula? | Excel Discussion (Misc queries) | |||
Linear Mode
