Axcel Problem........

[ismailshadab]

Piyaray dostoo Omeed karta hooon keh
aap sub theek hongay.....

Mera aik masla hai aur woh yeh keh jab main
Ms Axcel key cell main koi lamba digit type karkay
"enter" key press karta hoon to woh change ho jata
hai..........

For Ex. "20021127315331" changed into "2.00211E+13"

Agar kisi ko iska hal maloom ho tho zaroor bathain.........

[moon_6432000]

Ismail Bahi !
App cell Farmat change kar k "Number" kar den app ka masla hal ho jaye ga.
Cell par Right click kar k farmat Cell par click karen pir Category man Numbaer sellect karen aur Decimal places man "0" kar k Ok press karen.

[ismailshadab]

Ismail Bahi !
App cell Farmat change kar k "Number" kar den app ka masla hal ho jaye ga.
Cell par Right click kar k farmat Cell par click karen pir Category man Numbaer sellect karen aur Decimal places man "0" kar k Ok press karen.

Bohat Shukriya..............Moon..........bhai.......... ...

Meray....Khayal....main......default cell format "general" hee rehta hai...
is waja say yeh masla daitha hai.

[khatri4u]

w.salam
yar ap cell par right click karke use general main ja kar ok kar den thek ho jaega

[M-Qasim]

Jab Cell chota Hota Hai to Aysa Hota Hai
Aap Cell Ko Thora Khanch Kar Bada Kro Ge to Thik Show Hoga

[khatri4u]

yar ap cell par right click karen, format cell main ja kar general pe click kar ke ok kar den thek ho jaega

[syar]

salam::

Generally excel k aik cell m sirf 15 digit se zeyada number store nahee hote is leye excel is ko 10 k power m show karta ha. Is leye aap ko masla aaraha ha.AAp format cell m ja kar number select karain aur decimal place ko zero par set kar dain.Aap ka masla hal ho gaey ga.
Excel ki help m ja kar excel limitation k document ko check karain aap ko bohat se mazeed maloomat mil jae ge.

regards