In the OS Germany is set as my Country and English is set as Windows display language. When formatted as a percentage with zero decimal places the result is 7. Learn editing formatting navigation ribbon paste special data manipulation formula and cell editing and other.
Percent Change 5000 15000.
You can also use this trick to modify any other formulae you need so I suggest you keep this snippet of code handy Share. If youve entered a single-cell array formula select the cell press F2 make your changes and then press CtrlShiftEnter. But the formulas in Excel only work in German. REPLACE old_text start_num num_chars new_text As you see the Excel REPLACE function has 4 arguments all of which are required.