Am Freitag, 15. Juni 2012, 19:01:35 schrieb Michael Brand: > Hi Alexander > > On Fri, Jun 15, 2012 at 4:34 PM, AW <alexander.will...@t-online.de> wrote: > > [...] > > > > Desired outoput: > > | 100.00 | Value | > > | 150.00 | Value | > > > > #+TBLFM: $1=%s;%.2f > > > > [...] > > What you tried would be > > | 100.00 | Value | > | 150.00 | Value | > > #+TBLFM: $1=$0;%.2f > > $0 is the current table field. What I recommend is > > | 100.00 | Value | > | 150.00 | Value | > > #+TBLFM: $1 = $0 +.0; f-2 > > because of the behavior I explained in the tables shown here: > http://orgmode.org/worg/org-faq.html#table-float-fraction > > Michael
O.K., thank you very much for your help. This is a nice trick! Unfortunately, my tables have other formulas than only one: | Values | Desc. | |--------+-------| | 100.00 | Value | | 150.00 | Value | | 250. | sum | |--------+-------| | 500. | End | #+TBLFM: @4$1=@2$1+@3$1::@5$1=vsum(@I..@II)::$1=$0 +.0; f-2 I get at least every number in column 1 with a dot, but without ".00", as needed: *Do I have to ad '; f-2' to every formula?* And besides that, I've never seen this description "f-2". Is it explained somewhere for non-mathematicians? You know, if there are differences between this and ";%.2f", I should better be aware of them. Regards Alexander