Frankly, what you want to do is not easy, and you don't really have a need
for a solution, do you ?
If so, don't loose any time on this, it is not worth it.
Whomever is creating formulas in Excel should check their behavior before
"publishing" them (testing is part of designing).

That old peculiarity of Excel bombs out a few times a year on the web.

It's been around forever ( http://support.microsoft.com/kb/q132686/ ) and it
won't be changed anytime soon, if ever.

It is not a bug, just a different syntax interpretation than what is usually
expected.
But Excel is following precise and predictable rules in its syntax
interpretation, so I don't see this as such a big deal...

We all learned to live with it...

So no, Excel is not "computing the power of a negative number wrong", it
simply has bad reading discipline...

--
Regards,
Luc.

"Festina Lente"


"romelsb" wrote:

IN REFERENCE TO A SUGGESTION THREAD TITLED "Excel 2003 SP2 computes the power
of a negative number wrong", I kindly request your help to reestablished
confidence on engineer´s excel workbooks:
I NEED A FIND/REPLACE COMMAND FORMULA....
e.g.
=-A1^(A2+A3)
BASED FROM ABOVE :
I LIKE TO FIND ALL THE ABOVE AND REPLACE it with
=-1*A1^(A2+A3)
REGARDLESS WHETHER A1 IS A CELL REFEFRENCE OR A VALUE (2,3,4,....)...I HOPE
YOU GET MY REASON WHEN THE POWER IS AN EVEN NUMBER....
thanks and more power.....

--
"Bright minds are blessed to those who share them.."-rsb.