I'm sure this is a basic question but here it goes anyway.

When I delete the contents of a cell it will not recognize any formulas
even basic ones such as a cell ='s another cell. I have tried to copy a
good cell's format with the format painter but that didn't work. I have
to write the formula in a virgin cell then cut and past into the cell
that is miss behaving.

Thanks JG

When you delete the contents of a cell, use:

Edit Clear All

This will leave the format so as to be able to enter an equation.
--
Gary''s Student


"JG" wrote:

I'm sure this is a basic question but here it goes anyway.

When I delete the contents of a cell it will not recognize any formulas
even basic ones such as a cell ='s another cell. I have tried to copy a
good cell's format with the format painter but that didn't work. I have
to write the formula in a virgin cell then cut and past into the cell
that is miss behaving.

Thanks JG

Thanks I'll do that, is there a way to repair the damage that I have
already done ?

Thanks JG


Gary''s Student wrote:
When you delete the contents of a cell, use:

Edit Clear All

This will leave the format so as to be able to enter an equation.
--
Gary''s Student


"JG" wrote:

I'm sure this is a basic question but here it goes anyway.

When I delete the contents of a cell it will not recognize any formulas
even basic ones such as a cell ='s another cell. I have tried to copy a
good cell's format with the format painter but that didn't work. I have
to write the formula in a virgin cell then cut and past into the cell
that is miss behaving.

Thanks JG

I have a function working then if I make any change it isn't reconized.
Even if I place my courser in the formular bar and enter with the green
check the formular stops working.

below is what I am working with.
=ISNUMBER(MATCH(A36,Sheet1!H35:H47,0))*ISNUMBER(MA TCH(Sheet2!A36,Sheet1!O35:O47,0))
*ISNUMBER(MATCH(Sheet2!A36,Sheet1!V35:V47,0))

This is a large sheet and I am near the end. I have used this same
formula above with no issues.

HELP
thanks JG


JG wrote:
Thanks I'll do that, is there a way to repair the damage that I have
already done ?

Thanks JG


Gary''s Student wrote:
When you delete the contents of a cell, use:

Edit Clear All

This will leave the format so as to be able to enter an equation.
--
Gary''s Student


"JG" wrote:

I'm sure this is a basic question but here it goes anyway.

When I delete the contents of a cell it will not recognize any formulas
even basic ones such as a cell ='s another cell. I have tried to copy a
good cell's format with the format painter but that didn't work. I have
to write the formula in a virgin cell then cut and past into the cell
that is miss behaving.

Thanks JG

Format all the cells as General. Then Use Find and Replace to replace all "=" with "=" (yes, replace equals signs with equals
signs)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"JG" wrote in message ups.com...
|I have a function working then if I make any change it isn't reconized.
| Even if I place my courser in the formular bar and enter with the green
| check the formular stops working.
|
| below is what I am working with.
| =ISNUMBER(MATCH(A36,Sheet1!H35:H47,0))*ISNUMBER(MA TCH(Sheet2!A36,Sheet1!O35:O47,0))
| *ISNUMBER(MATCH(Sheet2!A36,Sheet1!V35:V47,0))
|
| This is a large sheet and I am near the end. I have used this same
| formula above with no issues.
|
| HELP
| thanks JG
|
|
| JG wrote:
| Thanks I'll do that, is there a way to repair the damage that I have
| already done ?
|
| Thanks JG
|
|
| Gary''s Student wrote:
| When you delete the contents of a cell, use:
|
| Edit Clear All
|
| This will leave the format so as to be able to enter an equation.
| --
| Gary''s Student
|
|
| "JG" wrote:
|
| I'm sure this is a basic question but here it goes anyway.
|
| When I delete the contents of a cell it will not recognize any formulas
| even basic ones such as a cell ='s another cell. I have tried to copy a
| good cell's format with the format painter but that didn't work. I have
| to write the formula in a virgin cell then cut and past into the cell
| that is miss behaving.
|
| Thanks JG
|
|
|

Thank you ....Herro!!!!!!!!!!!!!!!!!!!!!!!!!


Niek Otten wrote:
Format all the cells as General. Then Use Find and Replace to replace all "=" with "=" (yes, replace equals signs with equals
signs)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"JG" wrote in message ups.com...
|I have a function working then if I make any change it isn't reconized.
| Even if I place my courser in the formular bar and enter with the green
| check the formular stops working.
|
| below is what I am working with.
| =ISNUMBER(MATCH(A36,Sheet1!H35:H47,0))*ISNUMBER(MA TCH(Sheet2!A36,Sheet1!O35:O47,0))
| *ISNUMBER(MATCH(Sheet2!A36,Sheet1!V35:V47,0))
|
| This is a large sheet and I am near the end. I have used this same
| formula above with no issues.
|
| HELP
| thanks JG
|
|
| JG wrote:
| Thanks I'll do that, is there a way to repair the damage that I have
| already done ?
|
| Thanks JG
|
|
| Gary''s Student wrote:
| When you delete the contents of a cell, use:
|
| Edit Clear All
|
| This will leave the format so as to be able to enter an equation.
| --
| Gary''s Student
|
|
| "JG" wrote:
|
| I'm sure this is a basic question but here it goes anyway.
|
| When I delete the contents of a cell it will not recognize any formulas
| even basic ones such as a cell ='s another cell. I have tried to copy a
| good cell's format with the format painter but that didn't work. I have
| to write the formula in a virgin cell then cut and past into the cell
| that is miss behaving.
|
| Thanks JG
|
|
|