On Aug 27, 2008, at 6:18 AM, Parker, Matthew wrote:

> Is it possible to work w/ numbers w/ commas in 'spreadsheets'?

No, this is not possible.

- Carsten

>
> 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
>
>
> _______________________________________________
> Emacs-orgmode mailing list
> Remember: use `Reply All' to send replies to the list.
> Emacs-orgmode@gnu.org
> http://lists.gnu.org/mailman/listinfo/emacs-orgmode