Forum Discussion
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.
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).
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?
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.
