Jab mai 1 row mai 0003208 likta hon to jab is k nichy wali row mai maslan 0008238 likta hon. To yi hindson si pehli jo 000 hai yi hatam ho jati hai aor sirf 3208 reht jati hai.pls aisa tareqa bata dy k yi 000 b reh jai.
Jab mai 1 row mai 0003208 likta hon to jab is k nichy wali row mai maslan 0008238 likta hon. To yi hindson si pehli jo 000 hai yi hatam ho jati hai aor sirf 3208 reht jati hai.pls aisa tareqa bata dy k yi 000 b reh jai.
Cells ko 'number' k bajaay 'general' define kar len ...
Bhai general kaisi define karingi.?
Cell per right click karen, format cell per click karen , next window mn apni selection karen
Salam.
Mera khayal hai k 00 add ho saktey hain 000 nahi.
Last edited by Farhan213; 27th February 2013 at 10:17 PM. Reason: Edit in text
Bhaijan apna excel problem yahan se malum karein http://www.itdunya.com/t300546/
Aap ko ak method tu dosre dost n btaya k cell/range p right click karain. Ak aur method ya bhe ho sakta ha k apne cell/range select karain.
EXCEL 2007/2010 k HOME TAB m agar aap dekhain tu GENERAL lekha ho ga ya No. is p click karain tu drop box open ho ga. wahan sa TEXT select kar lain. Aap ka masla hal ho jae ga. aap jitney 000 chahe no sa pehle laga lain.
ya koi bhe number lekhne sa pehle singe quote ' lekh deya karain phe bhe aap ka masla ho jae ga.
Note: agar ap apne range text m convert krte hain tu phr aap ko sum/subtract ya calculation krne m masla ho ga.
regards
Cell format me aa kar custom me aaen.
General ko remove kar k 0 likh den 7 times. or ok kar den.
phir us cell me aap 3208 likhain gey to automatically 0003208 likha aa jae ga.
hahahha
Very good sab dosto ke bari bari mehrubani tanx.
Thread answered.....
Bookmarks