I often paste org-mode tables numbers that are e.g. space-separated. Then I have to delete spaces before things like
=$2/2 work correctly. Is there a way to change "number format", e.g. plug in a general function to parse input numbers in org-mode tables?
As an example, I'd like
| 100 000 | 0 | #+TBLFM: $2=$1/2
to give 50000, not 0, in column two (I don't care that the output is not space-separated).
I know about
;N, but that doesn't work either:
| 100 000 | 50 | #+TBLFM: $2=$1/2;N
and I'd rather have something that works on the full table because I'm sure to forget to put it on each formula.