Ap apni file ko attach karsakte hay ya phir screen shorts dein take ap ke swal ki samajh asani se aa sake.
Ap apni file ko attach karsakte hay ya phir screen shorts dein take ap ke swal ki samajh asani se aa sake.
Mera Eik Chota sa Masla Hai.
Column-A----Coulmn-B
WT -------30.25
Str -------100.00
Total ------ 3025
Pochna Ye Hai Coulmn ke Cells Ko Format Kesey Kron Ke
Coulmn-B 30.25 ki Jaga Sirf 25 Likhon Tu Wo 30.25 ban Jay.
Isi Tarha
Coulmn-B 100.50 ki Jaga Sirf 50 Likhon Tu Wo 100.25 ban Jay.
Yani Point(.) Se Pahley Ki Raqam Khud Add Ho jay.
Aur
Coulmn-B 3rd Mein In Dono Ko (x) krna hai.
My Problem Solved
http://www.itdunya.com/t343219/
Last edited by Arshad2579; 9th October 2012 at 12:51 PM.
Slmz.... Dear mujhay excel me aik problem arhi thi, mene wo aik thread bna k AAE me post kr dia tha, kindly ais k link pe ja k dekhen aur agr possible ho to meri hlp kren...
Syar Sir,
Aik problem lekar hazir huwa hoon wo yeh ke agar
a1=1180 Kilometers.
a2=150 Litres
a3=a1 / a2 jab karte hay to error ajata hey tu koi essa treeqa hay ke ham jab is tarah ki division krein to answer shi ajaye yani digits ke saath words honey ke ba wajood shi division ho jaye.
What is Micro in excel and how it works
Plz Explain
aap k leye bhe mere suggestion yahe ha jo m n is thread m d ha
http://www.itdunya.com/t342608/
aap bhe custom formating use karain. ya formula ko apne marze k mutabiq adopt kar lain.
wese m math ka koi acha student nahee hon lekan ak bat samjha nahee m k aap kase kilo meter ko litre sa divide karain g. ho sake tu mujhy zaroor bataye ga.
regards
Macro VB ka aik version ha jo k msoffice m use keya jata ha programming k leye use keya jata ha. is k zarye aap mukhtalif aise kam kar sakte hain jo k aap exce ya office k normal function sa nahee kar sakte. for example excel m aap color cell ki values nahee add kar sakte jab ka MACRO ya Coding k zarye aap asa kar sakte hain.
regards
nice
Bohat bohat shukria Syar Sahib mera masla hal ho gia hay.
Baqi wo jo ap ne poocha hay ke kilometer to litre se kyon divide kia jye ga to hmari aik statement vehicle ki hoti hay us mein:
If a1=Total kilometer covered in a month= ?kms
a2=Total fuel consumed in a month=?Litres
a3=Average millage per letre= a1/a2= ?kms.
Ab aap shaid samjh gye honge.
nice
ek choti si problem per meray liye kafi bari hai.
mera issue yai hai j ab hum excel main
A1:A1000 RANGE MAIN "PANADOL" TEXT MOJOOD HAI . AB AGERMAIN SAME NAME REENTER KARTA HON TO EXCEL WO NAME AUTCOMPLET KAR DATA HAI. SAME ISI TARAH KYA kisi or column main yani COLUMN D ya COLUMN F K KISI PARTICULAR CELL MAIN KYA WO NAME SHOW HO SAKTAY HAIN JAB HUM DATA ENTRY KARAIN.
UMEED HAI K MAIN APKO APNI BAT SAMJHANAY MAIN KAMYAB HUWA HONGA.
IN SHORT MERI SHEET MAIN 2000 PRODUCT NAME HAIN OR MAIN NE DGET FORMULA USE KIYA HAI OR MAIN CHAHTA HON K CRITERIA CELL MAIN JAB BHI DATABASE MAIN MOJOOD KOI NAME TYPE KARON TO WO AUTO COMPLETE HO JAYE.
Mere pass ek sheet hai. Jis mai maine invoice banahe hoe hai....mai chahta hon ke mai jb dist ka name likho to uska ntn number khod ba khod ajahe... Andazan 35 distributors hain....
Apke jawab ka intezar rahega..
File mai attached karaha hon.
Bookmarks