Deleting Cell with formulas with Numbers Ex. =2+3 not = A+B

[Samshun]

Deleting Cell with formulas with Numbers Ex. =2+3 not = A+B

I am trying to create a copy of workbook with only formulas, but some cells
exist wit
=2+3 which I do Not wanted. How can I delete all of this in a single click
(Not Individualy)

[RagDyer]

If you wish to delete *all* numeric formulas,

=A+B
*AND*
=2+3

Try this on a copy of your sheet:

<F5> and click on "Special".
Then click on "Formulas", and make sure that
*ONLY*
"numbers" is checked.
Then <OK>.

You will see that cells containing numeric formulas are selected.
Now, just hit <Delete>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Samshun" <[email protected]> wrote in message
news:[email protected]...
Deleting Cell with formulas with Numbers Ex. =2+3 not = A+B

I am trying to create a copy of workbook with only formulas, but some cells
exist wit
=2+3 which I do Not wanted. How can I delete all of this in a single click
(Not Individualy)

[swatsp0p]

Samshun: I don't believe what you ask is possible (without VB code), as Excel treats =2+3 and =A1+B1 as "numeric" formulas.

Plus, how can you tell whether a formula is numbers only (2+3) or an evaluation formula (A1+B1) that results in a number, without examining each formula? And what about mixed formulas (e.g. A12+2.75)?

Sorry.

[Samshun]

Thank you. Yes I can delete all as you said, But I only need to erase cells
having formula with =2+3 Only but not =A1+B1

"RagDyer" wrote:

> If you wish to delete *all* numeric formulas,
>
> =A+B
> *AND*
> =2+3
>
> Try this on a copy of your sheet:
>
> <F5> and click on "Special".
> Then click on "Formulas", and make sure that
> *ONLY*
> "numbers" is checked.
> Then <OK>.
>
> You will see that cells containing numeric formulas are selected.
> Now, just hit <Delete>.
> --
>
> HTH,
>
> RD
> ==============================================
> Please keep all correspondence within the Group, so all may benefit!
> ==============================================
>
>
> "Samshun" <[email protected]> wrote in message
> news:[email protected]...
> Deleting Cell with formulas with Numbers Ex. =2+3 not = A+B
>
> I am trying to create a copy of workbook with only formulas, but some cells
> exist wit
> =2+3 which I do Not wanted. How can I delete all of this in a single click
> (Not Individualy)
>
>