I have already made a workbook with all the formulas. (Lets call it a.xls)
In this work book I have made a formula as
Now I have made the same duplicate workbook (Lets call it as b.xls)
Now all the formulas in b.xls is shows as
and I want it to be shown as
Since I am having more than 1700 rows changing it one by one would be a lot of work.
Is there a simple way to do this