Deleting Cell Content

[Altec101]

Hello,

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

Thanks

[Jim Jackson]

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

[Tom Ogilvy]

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

[Ron de Bruin]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[Bernie Deitrick]

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" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>

[raypayette]

Perhaps you could convert it to text?

[Altec101]

Thanks guys for all your help.