How To Write Values With Zero In Ms Excel ???

[Baazigar]

HOW TO WRITE VALUES WITH ZERO IN MS EXCEL ???

FOR EXAMPLE 007

086

080

DEAR EXPERTS ! PLEASE HELP ME.

[Asad Mirjat]

simple hai...
app cell pe right click kar ke format ke option pe click karo aur Text ko select karo

[arifraza]

Press Ctrl+1
and Select Text Option from Number Category
see Attach image
---------------
arif kuwait

[Baazigar]

simple hai...
app cell pe right click kar ke format ke option pe click karo aur Text ko select karo

YES I GOT IT.

BAHOT BAHOT SHUKRIYA ....

[Baazigar]

Press Ctrl+1
and Select Text Option from Number Category
see Attach image
---------------
arif kuwait

I GOT FULLY,

THANK YOU VERY MUCH FOR YOUR HELP.

JAZAK ALLAH KHAIR ...

[habibrahet]

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.

[MALIKUMAIR]

Very Useful

[Baazigar]

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.

IT'S COMPLETE METHOD !!!

THANKS A LOT

JAZAK ALLAH KHAIR ......

[flydreamz]

By the way you can write like this '099, using upper comma ( ' )

[Baazigar]

By the way you can write like this '099, using upper comma ( ' )

WELL, THIS IS NEW BUT NOT MUCH USEFUL.

BY THE WAY, MANY THANKS FOR YOUR HELP....

[habibrahet]

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)

[syar]

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