Insert a helper column to the right of the values you want to transform and
in the first cell to the right of the first value, enter the following
formula modifying the A1 cell address to the cell address of your first value:

=VALUE(LEFT(A1,LEN(A1)-1))*-1

Copy down the entire length of the column.

Then select all the formula values in the helper column and copy them
(Ctrl+C). Move the first cell of the original values column, click EDIT in
the menu and select PASTE SPECIAL/VALUES.

YOu can now delete the helper column.

Hope this helps.
--
Kevin Backmann


"Karin" wrote:

How to change an amount, 523- to -523 in an easy way?