Question

What is difference between text and number data type in Excel?
I have checked in browser but i didn't find the answer.

Warning:
Don't copy paste the answer from net or u will be reported and ur account is goin to closed.

bye ​

Answer 1

Explanation:

You can enter numbers in text type but they would not be treated as numbers, only as a string of characters that can't be used in calculations.

But in number type, numbers can be used in calculations and you can't enter text in here as it would be invalid.