What Happens If You Type '123 in Excel? | Excel Quiz & Explanation

What happens when you type a number with an apostrophe before it in Excel, like '123? 🤔
In this quick Excel quiz tutorial, we’ll explain why Excel treats numbers differently when prefixed with an apostrophe and how this feature can be useful.

You’ll learn:
✅ Why '123 is stored as text instead of a number
✅ How to use the apostrophe to prevent unwanted number formatting
✅ Real-life cases where this trick saves time
✅ The difference between storing data as text vs numbers in Excel

💡 Correct Answer: A) Converts it to text
📊 Explanation: The apostrophe forces Excel to store and display the value as text, even if it’s a number.

This trick is especially useful for entering IDs, phone numbers, ZIP codes, or codes with leading zeros.

#Excel #ExcelTips #ExcelQuiz

Видео What Happens If You Type '123 in Excel? | Excel Quiz & Explanation канала Quizziin