Is it possible to work w/ numbers w/ commas in
'spreadsheets'?
when trying to add 3,000 to 4,000 below...
=$1+$2
... yields 7
and this works but is long winded:
@2$3='(+ (string-to-number
(replace-regexp-in-string "," "" $1)) (string-to-number
(replace-regexp-in-string "," "" $2)) )
I reviewed the chapter on tables... am I missing something
simple?
Thanks
| one |
two |
sum
|
|---------+---------+-----------------------|
| 3000 | 4000 |
7000
|
| 3,000 | 4,000 |
7
|
| 3,000 | 4,000 |
7000
|
| "3,000" | "4,000" | [103, 88, 96,
96, 96] |
| 3\,000 | 4\,000 |
#ERROR
|
| '3,000' | '4,000' |
#ERROR
|
#+TBLFM: @2$3='(+ (string-to-number
(replace-regexp-in-string "," "" $1)) (string-to-number
(replace-regexp-in-string "," "" $2)) )::@3$3=$1+$2