emacs-orgmode
[Top][All Lists]
Advanced

[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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]