Check out another answer to your first post.

Much easier than formulas.


Gord Dibben Excel MVP

On Thu, 14 Apr 2005 07:21:06 -0700, "Wallaby"
wrote:

Thanx Arno and Jason

Arno your formula give me an error message "value" once typed in. I assume
that it must be the formatting. when I type in a number 15- it converts, but
with the number as 21.561,00- no luck.

"arno" wrote:

Hi Jason,

Replace With: <leave empty

cool, this will turn a list of positive and negative values into a list
of absolute values. Why bother with those bloody minuses, just throw
them away!

arno