Forum Discussion

GokhanG's avatar
GokhanG
Copper Contributor
Nov 03, 2023

Formulas in tables changes language automatically when inserting new row

I have a table where I calculate day, month and year values in other columns based on the entered date values. I use this spreadsheet on my Mac and iPhone. When I go back to using the document on a...
Excel on Mac
Formulas and Functions
office 365
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Nov 11, 2023

GokhanG 

It seems that Excel might be trying to change the formulas to a different language based on the operating system or regional settings. If you are sure your settings are consistent across devices, here is an approach that might resolve the issue:

  1. Check the Formula Locale Settings:
    • Confirm that the formula language settings are consistent on your Mac and iPhone.
    • In Excel for Mac, check the language settings under Excel -> Preferences -> International.
    • On your iPhone, verify the system language settings that might affect Excel formulas.
  2. Convert to English Formula:
    • One potential solution is to use English formulas that work universally across devices. For instance, use DAY(), MONTH(), and YEAR() instead of the Turkish counterparts (GÜN(), AY(), YIL()).
  3. Check Table Options:
    • In Excel for Mac, verify the Table options for any specific language or formula settings that might be affecting the table's behavior.
  4. Excel Version and Updates:
    • Ensure you are using the latest version of Excel on both your Mac and iPhone.
    • If there's a specific issue tied to the application's version or updates, checking for available updates might resolve the problem.

If the problem persists despite these checks, it might be worthwhile to reach out to Microsoft Support or Excel support forums to address the issue. They might have specific troubleshooting steps or insights based on the behavior of the formulas.

 

NOTE: My knowledge of this topic is limited, but since no one has answered it for at least one day or more, I entered your question in various AI. The text and the steps are the result of various AI's put together. Maybe it will help you further in your project, if not please just ignore it.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.

Resources