Why is your SUM formula failing? 🛑👇 ​It’s because you are typing text (like "kg") next to your numbers. Excel can't do math with text! ​Here is the fix: 1️⃣ Select your cells. 2️⃣ Press Ctrl 1. 3️⃣ Select Custom. 4️⃣ In the box type: 0 "kg" (or "pcs", "cm", etc.) 5️⃣ Hit OK. ​Now Excel treats it as a number, but shows the text. 🤯 ​✅ Save this so you don't forget the code! 🚀 Follow @excelfunclub for daily tips! ​#excel #exceltips #customformatting #dataanalytics #officehacks #exceltricks #lea

Common Errors in Excel‼️ 🗂️ Don't forget to save this post! 🧑‍🏫 Get your FREE Excel templates with the link in our bio! 🤯 Follow us on TikTok, YouTube, Twitter, Threads, and more with the link in our bio! #excel #exceltips #exceltricks #spreadsheets #corporate #accounting #finance #workhacks #tutorials | CheatSheets