[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] Formatting a calculated cell entry as currency
From: |
Eric S Fraga |
Subject: |
Re: [O] Formatting a calculated cell entry as currency |
Date: |
Fri, 7 Jun 2013 20:00:49 +0100 |
User-agent: |
Gnus/5.130008 (Ma Gnus v0.8) Emacs/24.3.50 (gnu/linux) |
Nick Dokos <address@hidden> writes:
> address@hidden (J. David Boyd) writes:
>
>> I've got a simple cell calculation, address@hidden * 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