Enter -1 in an empty cell.

Copy that cell. Select your positives and Paste SpecialMultiplyOKEsc


Gord Dibben Excel MVP

On Thu, 23 Jun 2005 17:42:02 -0700, "ctdak"
wrote:

I have many cells with positive numeric content that I need to change to
negative numbers without changing the absolute value of the numbers. Is
there a way to highlight a block of cells and have a negative sign inserted
in all of them? It will take me forever to do this manually.