Numbers how to get formula show updated Column Header?
Numbers showing previous Column Header instead of revised header.
Should formula show revised header?
iOS 16.0.2
iPhone XR, iOS 16
Apple Intelligence is now available on iPhone, iPad, and Mac!
Numbers showing previous Column Header instead of revised header.
Should formula show revised header?
iOS 16.0.2
iPhone XR, iOS 16
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
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"?
thanks. i found my problem. i need to switch from Excel mindset to Numbers
Numbers how to get formula show updated Column Header?