Numbers how to get formula show updated Column Header?

Sunnyintoronto123 wrote:

Numbers showing previous Column Header instead of revised header.

From your screenshot it seems you are using Numbers for iOS/iPadOS (instead of Numbers for Mac, the subject of this forum).

If so, then the 'str convert to ascii' in the formula refers to the 'convert to ascii' row of the 'str' column.

In Numbers for Mac preferences you can turn off Use header names as labels to see row number cell letter type of reference in formulas, but I don't think that is possible in Numbers for iPad/iOS

SG

I do not understand what you want it to do. SGIII explained that "str convert to ascii" is referring to cell B2. What do you want it to do differently? What cell do you want it to refer to? What cell are you calling the "previous column header"? What cell are you calling the "revised header"? What do you expect for the result in cell F2, if not the word "ten"?