Formatting a calculated cell entry as currency

Formatting a calculated cell entry as currency

[J. David Boyd]

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.

Dave

Re: Formatting a calculated cell entry as currency

[Nick Dokos]

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):

--8<---------------cut here---------------start------------->8---
| a | b      |
|---+--------|
| 1 | $8.25  |
| 2 | $16.50 |
| 3 | $24.75 |
#+TBLFM: $2 = 8.25*$1;$%.2f
--8<---------------cut here---------------end--------------->8---

-- 
Nick

Re: Formatting a calculated cell entry as currency

[Eric S Fraga]

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