Nick Dokos <ndo...@gmail.com> writes: > da...@adboyd.com (J. David Boyd) writes: > >> I've got a simple cell calculation, =@2 * 40 >> >> If @2 contained 10, is there anyway to force this to show as $400.00? I've >> combed through the info file, and if it is there I'm blind. >> > > This seems to work (apart from the alignment): > > | a | b | > |---+--------| > | 1 | $8.25 | > | 2 | $16.50 | > | 3 | $24.75 | > #+TBLFM: $2 = 8.25*$1;$%.2f
For David's benefit, if alignment matters, you could use something like ";$%6.2f" for the formatting specification (with 6 changed to something that is appropriate for the scale of values you expect and whether you like a space after the $). -- : Eric S Fraga, GnuPG: 0xC89193D8FFFCF67D : in Emacs 24.3.50.1 and Org release_8.0.3-193-g334581
