[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [O] org-spreadsheet: formatting chops off units
From: |
Michael Brand |
Subject: |
Re: [O] org-spreadsheet: formatting chops off units |
Date: |
Thu, 6 Sep 2012 07:15:33 +0200 |
Hi Kyle
On Wed, Sep 5, 2012 at 11:46 PM, Kyle Andrews <address@hidden> wrote:
> If you type in '0.66138679 lb into calc directly, and press d f 2, calc
> displays 0.66 lb as desired. Is there any reason for the %.2f notation
> chops off the units? Is there some better way to accomplish what I
> want?
Org spreadsheet gives access to the format of calc, use
#+TBLFM: $2=uconvert($1, lb);f-2
or less recommended the format of Org spreadsheet with a text
#+TBLFM: $2=uconvert($1, lb);%.2f lb
Michael