One way:

A1: 10
B1: =-A1

In article <5b144ff31badd@uwe,
"Danny Boy via OfficeKB.com" <u15117@uwe wrote:

Hi there,

I have a values + or - in one column and the number in the next

What I want to do is add the + or - to the number i.e.

- in one column, 10 in the next you get -10

I know I can do this by using the & function but this is not the way I want
to do it

I don't want it to lookup, I would like it to be permament, and it must
totally replace the value 10 with -10 as in the above example

I hope this is not clear as mud, Hope someone can help