Excel supports several data types, including :
- Text (String) – Any combination of letters, numbers, and symbols treated as text (e.g., "Hello", "ABC123").
- Number – Numeric values used for calculations (e.g., 10, 3.14, -25).
- Date and Time – Represents dates and times, stored as serial numbers (e.g., "01/01/2025", "12:30 PM").
- Boolean (Logical) – TRUE or FALSE values used in logical operations.
- Error – Displays errors when a formula or function fails (e.g.,
#DIV/0!, #VALUE!).
- Currency – A number formatted with a currency symbol (e.g., $100.00).
- Percentage – Numeric values displayed as a percentage (e.g., 50% is stored as 0.5).
- Fraction – Numbers displayed as fractions (e.g., 1/4 instead of 0.25).
- Scientific (Exponential) – Large or small numbers shown in scientific notation (e.g., 3.5E+10).
- Custom Data Types – Power Query and newer versions of Excel allow custom data types that can include multiple values (e.g., Stocks, Geography).
