why does the formula show instead of the result when copying?

R

rws

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.
 
J

JoeU2004

rws said:
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.
Click to expand...

If all cells show formulas, look at the Formulas Windows option under Tools
Options > View (Excel 2003). Be sure that it is not checkmarked.
Click to expand...

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.
 
Top