Forum Discussion

shleshavan's avatar
shleshavan
Copper Contributor
Aug 15, 2024

Cell Recognition for formula

Everytime I insert a new row in excel, the cells don't seem to be recognised and the formula shows #Value. I tried formatting it into number and currency, but it doesn't work. 
Excel
Formulas and Functions
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Aug 15, 2024

shleshavan You don't show the formula, but I suspect that it errors out because you are dealing with texts that look like numbers. Formatting a cell to Number when it contains a text doesn't turn that text into a number.

What number format do you use in your locale? Decimal point or comma?

Check your 'numbers' with the function =ISNUMBER(cell_ref). 

  • shleshavan's avatar
    shleshavan
    Copper Contributor
    Aug 15, 2024

    Riny_van_Eekelen You are right. Using comma instead of point fixed the problem. Is there a way to change decimal to point instead of comma for all the cells? 

    • Riny_van_Eekelen's avatar
      Riny_van_Eekelen
      Platinum Contributor
      Aug 15, 2024

      shleshavan That's done in Windows regional settings.  In W11, it's hidden away under:

      Settings, Region Settings, Related > Administrative Language Settings. Then 'Formats', Additional Settings.

       

      Google to find how to do that in case you are using a different Windows version.

       

Resources