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.
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.