Quick and dirty mit AppleScript

Code in den Script Editor kopieren und starten.
Dann die Spaltennummer eingeben. Alle negativen Zahlen (kein Text) werden positiv.


Show Plain Text
  1. repeat
  2.   try
  3.     set columnString to text returned of (display dialog "Bitte Spaltennummer eingeben (A=1)" default answer "1")
  4.     set columnNumber to columnString as integer
  5.     exit repeat
  6.   end try
  7. end repeat
  8. tell application "Numbers"
  9.   tell table 1 of sheet 1 of document 1
  10.     repeat with i from 1 to row count
  11.       tell column columnNumber
  12.         set theValue to value of cell i
  13.         if class of theValue is real and theValue < 0 then set value of cell i to -(theValue)
  14.       end tell
  15.     end repeat
  16.   end tell
  17. end tell
----------
Gruss

Stefan