Subscript based on cell value

I would like to format a cell like dt=600.
That 600 is the content of another cell which might be altered and this alteration should be reflected in the subscript value.


It appears that you can change character position with fixed data, but not when referencing another cell. In this case, the text reverts to normal.

You can use Unicode subscript characters (₀₁₂₃₄₅₆₇₈₉).

Paste the following formula into the cell that will display the formatted text (* dₜ₌₆₀₀ *), replacing A1 with the reference to the cell to be altered (by typing 600):


It doesn’t seem an elegant formula to me, but it does the job.

Sample file: Unicode subscripts.ods

Subscript 0’s code is 2080, 1’s is 2081, and so on; 209C for and 208C for . If do you type 2080 and inmediatelly press Alt+X it appear a .

Normal 0’s code is 0030, 1’s is 0031, and so on.

Table of Unicode Superscripts and Subscripts.

Table of Unicode Phonetic Extensions.

Edit your question if you want to add more information; also can comment an answer (Add Answer is reserved for solutions).

Check the mark (Correct answer mark) to the left of the answer that solves your question.

not quite elegant, but at least a solution