View Single Post
  #5   Report Post  
Wallaby
 
Posts: n/a
Default

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