HOW TO WRITE VALUES WITH ZERO IN MS EXCEL ???
FOR EXAMPLE 007
086
080
DEAR EXPERTS ! PLEASE HELP ME.
HOW TO WRITE VALUES WITH ZERO IN MS EXCEL ???
FOR EXAMPLE 007
086
080
DEAR EXPERTS ! PLEASE HELP ME.
simple hai...
app cell pe right click kar ke format ke option pe click karo aur Text ko select karo
Press Ctrl+1
and Select Text Option from Number Category
see Attach image
---------------
arif kuwait
iss tareeqay say enter ki gai value number nahi rahay gi, matlab, ab aap iss value ko add, subtract, multiply, etc kuch nahi kar saktay. matlab excell use karnay ka maqsad he khatam ho gaya.
sahi tareeqa yeh hay k value be wohi nazar aaey jo aap chahtay hain, or NUMBER b rahay.
is kay liay
aap CELL per right click karen, NUMBER tab per jaen, (jahan aap nay text select kiya thaa) woheen per sab say neechay CUSTOM per click karen, us kay saath he aap ko type ki baar nazar aaey gi, ab aap jitni digits per apna number visible dekhna chahtay hain utnay he zero (0) daal dain
jaisay
007 k liay 3 zero enter kar deejiay (e.g. 000)
07 k liay 2 zero enter kar deejiay ( e.g. 00)
aor ok kar dain, ab aap kay number aap ki khawahish kay mutabiq nazar aaen gay, aor rahain gay bhee number he, aap in per tamam formula use kar saktay hain.
baqi attch image main dekh lain.
Very Useful
By the way you can write like this '099, using upper comma ( ' )
yeh solution nahi, sirf kaam chalanay wali baat hay, mager kaam bhee mukammal nahi nikalta iss tareeqay say, adhoooora he nikalta hay,,
coz main ooper keh chuka hoon k iss tareeqay say value , value nahi rehti, sirf text ban jati hay, iss per aap koi function apply nahi kar saktay, (iss baat ko zehan main rakhain, k excell issi waja say use kiya jata hay k aap different functions use kar k apna kaam asaan banaen, ager function he na chalay, to excel ka faida kaya)
salam::
aap text number ko sum, product ya kisi bhe function main istimal kar sakte hain.
Is k leye zaroori ha ka aap" --" ka sign istimal karain.
suppose aap ka a1 main '1 aur a2 main '2 likha howa ha in ko sum karne k leye
=sum(--a1:a2)
=product(--a1,--a2)
=mod(--a1,--a2)
but they are array formulas hso must be confirmed with "control+shift+enter" not just enter
regards
Bookmarks