
If + ISNUMBER + ISTEXT

You can quickly format numbers in Excel using the following keyboard shortcuts:
- General format: Ctrl + Shift + ~
- Currency format: Ctrl + Shift + $
- Percentage format: Ctrl + Shift + %
- Scientific format: Ctrl + Shift + ^
- Date format: Ctrl + Shift + #



