Forum Discussion
Excel reads bulk replacement as formula = ERROR
Hi Guys, I would like to do a simple bulk replacement in Excel but it's preventing me with this message: There's a problem with this formula: Not trying to type a formula? When the first charac...
Numbers in Excel should use the decimal separator specified in the computer's settings (or in Excel's options). They will then change from point to comma or vice versa automatically on other computers.
Trying to change them manually by Find/Replace is going to cause problems with the formulas in most situations, as you have found.
Thank you HansVogelaar for the reply.
But it was working before. I also set my language settings in French.
Anyway, turns out I didn't have to highlight the row where these changes are to be applied. I only had to click one row and all three columns were changed.
But it was working before. I also set my language settings in French.
Anyway, turns out I didn't have to highlight the row where these changes are to be applied. I only had to click one row and all three columns were changed.