it was ok that peo's suggestion wiped out the original number. though i would
have preferred the formula to the final value, but i just footnoted the
multiplier so it worked out fine. thank you.

"Gord Dibben" wrote:

The macros suggested will also obliterate the original number.

As far as "made short work" just open the backup copy you made before you tried
Peo's suggestion.


Gord Dibben MS Excel MVP

On Sun, 30 Sep 2007 13:36:01 -0700, sharon
wrote:

Peo's solution worked as
well, but obliterated the original number (i.e. no formula to see what i did)
Thanks Peo that made short work of many many manual edifications.