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