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 character is an equal ("=").......
I only want to replace all the decimal periods with a comma, as the figures are supposed to be French amounts. I can do it one by one, but it's too many to do.
Please help, since these amounts are related to a formula in another column, which turns to error if not replaced.
Thank you in advance.
2 Replies
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.
