View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default Clearing formulas

Hello all,

Is there a way to save a worksheet and at the same time delete a formula
from a certain cell?

IE:
Cell P1 has a formula +If(Ag101=1,AG100,AG99)

AG99= 12 AG100= 15 AG101=1

Cell P1=15

When I save this sheet I want the information in P1 to stay but the formula
to be gone. So when I pull up the sheet again in cell P1 the information is
there but no formula. Is this possible?

ERic