I dulicate a large series of cells that are all positive. Is there a
shortcut to change them to all negaive?
I dulicate a large series of cells that are all positive. Is there a
shortcut to change them to all negaive?
Hi,
Type -1 in a cell, copy that and then select the range, which has the
positive numbers which you want to convert to negative.
Right click on the range, select paste special, and choose action as
'Muliply'.
Regards
Govind.
Stuart Millner wrote:
> I dulicate a large series of cells that are all positive. Is there a
> shortcut to change them to all negaive?
Perfect, thanks a million, what an easy solution....
"Govind" wrote:
> Hi,
>
> Type -1 in a cell, copy that and then select the range, which has the
> positive numbers which you want to convert to negative.
>
> Right click on the range, select paste special, and choose action as
> 'Muliply'.
>
> Regards
>
> Govind.
>
> Stuart Millner wrote:
> > I dulicate a large series of cells that are all positive. Is there a
> > shortcut to change them to all negaive?
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks