What happens if we makes the corrections in the data after typing formula ? Do we need to type the formula again or there is some facility in MS-excel to avoid retyping
Answers
Answered by
8
Explanation:
When you set the cell formatting to “Text”, Excel treats the formula as text and shows it instead of evaluating it. To fix this error, just select the cell, set its formatting to “General”. Now edit the formula and press enter. (Alternatively you can press F2 and then Enter after setting format to General).
Answered by
1
Answer:
I hope answer is helpful to us
Attachments:
Similar questions