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?