4

Consider the following table:

|--------+------|
| Number |    % |
|--------+------|
|  0.004 | 0.40 |
| 0.0047 | 0.47 |
|   0.01 | 1.00 |
|  0.019 | 1.90 |
|--------+------|
#+TBLFM: $2=$1*100; %.2f

How could I change $2 formula so it would look like this:

|--------+-------|
| Number |     % |
|--------+-------|
|  0.004 | 0.40% |
| 0.0047 | 0.47% |
|   0.01 | 1.00% |
|  0.019 | 1.90% |
|--------+-------|
1
  • 1
    Note that you probably don't want to do that on any column that is going to be used as input to another calculation: prettify output columns only.
    – NickD
    May 11, 2023 at 15:20

1 Answer 1

5

You can add arbitrary text after the formatting. To get a % you need to double the symbol

|--------+-------|
| Number |     % |
|--------+-------|
|  0.004 | 0.40% |
| 0.0047 | 0.47% |
|   0.01 | 1.00% |
|  0.019 | 1.90% |
|--------+-------|
#+TBLFM: $2=$1*100; %.2f%%

Not the answer you're looking for? Browse other questions tagged or ask your own question.