Hi Folks,
Today I faced a strange issue. When I enter the cell value ABC in A2 and apply the =Proper(A2) I get Abc.
But when I paste the same formula to B3 cell value with formula =Proper(B2) for B2 value DEF I am still getting Abc instead of Def.
The same issue repeated for all formulas.
After trying various options in excel, I was able to find the resolution.
All I had to do was :
Click on Formulas tab >Calculation Option>And choose Automatic option
Viola!
My formula values were back
Today I faced a strange issue. When I enter the cell value ABC in A2 and apply the =Proper(A2) I get Abc.
But when I paste the same formula to B3 cell value with formula =Proper(B2) for B2 value DEF I am still getting Abc instead of Def.
The same issue repeated for all formulas.
After trying various options in excel, I was able to find the resolution.
All I had to do was :
Click on Formulas tab >Calculation Option>And choose Automatic option
Viola!
My formula values were back
No comments:
Post a Comment