Data types: text, number, date, boolean — Excel internally kaise store karta hai

Excel har cell me sirf 4 tarah ka data samajhta hai — aur inhe pehchanna zaroori hai kyunki formulas galat cheez ke saath galat behave karte hain.

Yeh alignment hint hi tumhara sabse pehla debugging tool hai — agar number left-aligned dikh raha hai, wo number nahi, text hai.

Andar se Excel kya store karta hai:

• Number — seedha binary floating point number. 12.5 matlab 12.5.
• Date — ek serial number, jahan 1 = 1 January 1900. Aaj ki date ek 5-digit number hai (~46000s range me). Isiliye =Date2 - Date1 seedha subtract ho jaata hai — dono numbers hi hain.
• Time — date ke serial number ka fraction. 12:00 PM = 0.5 (aadha din). 01-Mar-2026 12:00 PM = 46000.5 jaisa kuch.
• Boolean — TRUE = 1, FALSE = 0 internally. Isiliye =TRUE+TRUE ka answer 2 aata hai.
• Text — kuch bhi jo upar wale 3 me fit nahi hota, ya jisse tum forcefully text banao.

=TODAY()          → serial number dikhta hai jab tak format date na ho
=TODAY()+7        → 7 din baad ki date (kyunki dates numbers hain)
=TRUE+TRUE+FALSE  → 2

[SS-1: same value 45678 shown in two cells — one formatted as date "15-Jun-2025", one as plain number "45678"]

Sabse common problem: number/date "text ke roop me" store ho jaana

Jab data CSV se import hota hai, ya kisi system se copy-paste hota hai, numbers/dates kabhi-kabhi text ban jaate hain — dikhte number jaise hain, par Excel unhe text samajhta hai.

Pehchaan:

• Cell left-aligned hai lekin number jaisa dikh raha hai
• =SUM() unhe ignore kar deta hai (0 aata hai jab expect kar rahe ho kuch aur)
• Cell ke top-left corner me chhota green triangle (error indicator)

=ISTEXT(A1)     → TRUE agar A1 me text-as-number hai
=ISNUMBER(A1)   → FALSE isi case me

Fix karne ke 2 tareeke:

1. Cell(s) select karo → chhota warning icon (⚠) pe click → "Convert to Number"
2. Formula se: =VALUE(A1) (number ke liye) ya =DATEVALUE(A1) (date ke liye)

Yaad rakho: Jo bhi Excel me aata hai — VLOOKUP na milna, SUM ka 0 dikhna, sort galat hona — sabse pehle check karo: kya yeh sahi data type hai? 80% "Excel kaam nahi kar raha" issues yahi hote hain.