Deleting Cell Content
 

Hello,

Is there a way that I can delete a cells content without deleting th
formula in that cell?

Thank

--
Altec10
-----------------------------------------------------------------------
Altec101's Profile: http://www.excelforum.com/member.php...fo&userid=3453
View this thread: http://www.excelforum.com/showthread.php?threadid=57077

Deleting Cell Content
 

The only thing I can think of is to set the font color to white which will
cause the cell to appear empty. You probably would want to protect the cell
to prevent its being ovwewritten.
--
Best wishes,

Jim


"Altec101" wrote:


Hello,

Is there a way that I can delete a cells content without deleting the
formula in that cell?

Thanks


--
Altec101
------------------------------------------------------------------------
Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539
View this thread: http://www.excelforum.com/showthread...hreadid=570778

Deleting Cell Content
 

no. the cells content is the formula.

--
Regards,
Tom Ogilvy

"Altec101" wrote:


Hello,

Is there a way that I can delete a cells content without deleting the
formula in that cell?

Thanks


--
Altec101
------------------------------------------------------------------------
Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539
View this thread: http://www.excelforum.com/showthread...hreadid=570778

Deleting Cell Content
 

Hi Altec

Maybe you can clear the cells that the formula use and have the formula display "" if the cell or cells are empty.
What do you want to do exactly ?


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Altec101" wrote in message
...

Hello,

Is there a way that I can delete a cells content without deleting the
formula in that cell?

Thanks


--
Altec101
------------------------------------------------------------------------
Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539
View this thread: http://www.excelforum.com/showthread...hreadid=570778

Deleting Cell Content
 

Re-write your OLDformula like this:

=IF(A1="","",OLDFormula)

and blank out A1 when you want the cell to appear blank.

HTH,
Bernie
MS Excel MVP


"Altec101" wrote in message
...

Hello,

Is there a way that I can delete a cells content without deleting the
formula in that cell?

Thanks


--
Altec101
------------------------------------------------------------------------
Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539
View this thread: http://www.excelforum.com/showthread...hreadid=570778

Deleting Cell Content
 

Perhaps you could convert it to text?


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=570778

Deleting Cell Content
 

Thanks guys for all your help.


--
Altec101
------------------------------------------------------------------------
Altec101's Profile: http://www.excelforum.com/member.php...o&userid=34539
View this thread: http://www.excelforum.com/showthread...hreadid=570778