Computer Science, asked by anubhav122137, 1 month ago

can we perform calculation on number treated as text? In worksheet in excel​

Answers

Answered by shivamkumra
3
Yes you can perform calculation on number treated as text in excel
Answered by deepashetty151982
3

Figure 1: The Text format prevents you from using numbers with mathematical functions. The Text format in a cell displays the contents of a worksheet cell rather than its result. Thus, if you enter a formula in a cell formatted as text, the underlying formula will appear in your worksheet cell rather than the result.2

Similar questions