Cells loosing there functions
 

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

Cells loosing there functions
 

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

Cells loosing there functions
 

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

Cells loosing there functions
 

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

Cells loosing there functions
 

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

Cells loosing there functions
 

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