Write cell formula: why my formula become lower case


This my formula, why my result in excel is this become =MAX($worksheet.$k:$k)


Welcome to the community!

Can you recheck the activity where you’re writing the formula in the cell?

I used write cell workbook


The reason for this conversion is that Excel treats function names, worksheet names, and column references as case-insensitive. It is a default behavior of Excel to convert them to a consistent case, typically lowercase, for better readability.

The formula “=MAX($worksheet.$k:$k)” will still function correctly and calculate the maximum value in the specified range. The case of the formula does not impact the calculation.