From mboxrd@z Thu Jan  1 00:00:00 1970
From: Eric S Fraga <e.fraga@ucl.ac.uk>
Subject: Re: Formatting a calculated cell entry as currency
Date: Fri, 7 Jun 2013 20:00:49 +0100
Message-ID: <87vc5pagpq.fsf@ucl.ac.uk>
References: <m9hiobbjndfr.fsf@D2SL3K1.usac.mmm.com>
	<87fvwunc7a.fsf@pierrot.dokosmarshall.org>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:43380)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <e.fraga@ucl.ac.uk>) id 1Ul2YD-0008PX-1T
	for emacs-orgmode@gnu.org; Fri, 07 Jun 2013 15:42:18 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <e.fraga@ucl.ac.uk>) id 1Ul2YC-0008PS-18
	for emacs-orgmode@gnu.org; Fri, 07 Jun 2013 15:42:16 -0400
Received: from tx2ehsobe001.messaging.microsoft.com ([65.55.88.11]:19291
	helo=tx2outboundpool.messaging.microsoft.com)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <e.fraga@ucl.ac.uk>) id 1Ul2YB-0008CE-Ps
	for emacs-orgmode@gnu.org; Fri, 07 Jun 2013 15:42:15 -0400
In-Reply-To: <87fvwunc7a.fsf@pierrot.dokosmarshall.org> (Nick Dokos's message
	of "Thu, 6 Jun 2013 17:47:37 -0400")
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Nick Dokos <ndokos@gmail.com>
Cc: emacs-orgmode@gnu.org

Nick Dokos <ndokos@gmail.com> writes:

> david@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