Org mode: How to escape the # character in a table formula

Question

I am trying to rename a row inside a table using a formula in Org mode (don't ask why I'm doing this, I need to do it that way) but I'd like to call this row #. I'm doing this:

| #ERROR | B | C |
|--------+---+---|
|      1 | 2 | 3 |
|      1 | 2 | 3 |
#+TBLFM: @1$1=#

As you can see I'm getting an error. I guess that's because # is a special character reserved to indicate line numbers.

So I'd like to know how to escape this character to interpret it as a normal string.

Answer 1

The following works because you can write table formulas with elisp code. Notice the ' (quote) before the s-exp.

| # | B | C |
|---+---+---|
| 1 | 2 | 3 |
| 1 | 2 | 3 |
#+TBLFM: @1$1='(format "#")

Evaluate (info "(org) Formula syntax for Lisp") for more information.