I use that a lot when I copy and paste special and want to add negative
values,
however in a formula Biffs' solution is better


--

Regards,

Peo Sjoblom




"cal_coach_26" wrote in message
...
Many thanks - made me think!

"Peo Sjoblom" wrote:

Negative number in A1

=A2-A1

will be the same as =A2+A1 with a positive number in A1


--

Regards,

Peo Sjoblom




"cal_coach_26" wrote in message
...
If a number is on the spread sheet as negative, but for another
calculation
you want to use the number as a positive - is there anyway to do it?