Excel Help Line مائیکرو سافٹ ایکسل ہیلپ لائن سینٹر

[M Imran Mugal]

Dear "MFRANAKAR" Excel2007 me aik sawal hai mera bry mehrbani help kejey ga........
me database bna raha hn us me student date of birth likhni hai Figer me b aur Words me b to kiya aisa mumkin hai k me date (Exp 09-05-2013) likho to wo "in word" waly cell me words(Exp: Ninth May Two Thousand thirteen) me khod ba khod likhi jay.

[sohail1966]

Dear "MFRANAKAR" Excel2007 me aik sawal hai mera bry mehrbani help kejey ga........
me database bna raha hn us me student date of birth likhni hai Figer me b aur Words me b to kiya aisa mumkin hai k me date (Exp 09-05-2013) likho to wo "in word" waly cell me words(Exp: Ninth May Two Thousand thirteen) me khod ba khod likhi jay.

is ka Shi hal to Sirf Syar Sahib hi dein saktay hain.

[syar]

Dear "MFRANAKAR" Excel2007 me aik sawal hai mera bry mehrbani help kejey ga........
me database bna raha hn us me student date of birth likhni hai Figer me b aur Words me b to kiya aisa mumkin hai k me date (Exp 09-05-2013) likho to wo "in word" waly cell me words(Exp: Ninth May Two Thousand thirteen) me khod ba khod likhi jay.

Automatic tu Nahee ho ga. Formula k through ho ga aur formula aap ko lagana ho ga jis k leye aap KO VBA ki programming krne ho gi. agar aap ka matloba masla hal hota ha tu try this procedure otherwise wait for others expert k aap ki problem solve karain.


--- Open your excel Sheet
--- Press Alt+F11
--- Open hone wale window m Insert k menu m jain
--- Module Select Karain
---- Ya code copy kr k paste kar dain.

Function DateToWords(ByVal DateIn As Variant) As String
Dim Yrs As String
Dim Hundreds As String
Dim Decades As String
Dim Tens As Variant
Dim Ordinal As Variant
Dim Cardinal As Variant
Ordinal = Array("First", "Second", "Third", _
"Fourth", "Fifth", "Sixth", _
"Seventh", "Eighth", "Nineth", _
"Tenth", "Eleventh", "Twelfth", _
"Thirteenth", "Fourteenth", _
"Fifteenth", "Sixteenth", _
"Seventeenth", "Eighteenth", _
"Nineteenth", "Twentieth", _
"Twenty-first", "Twenty-second", _
"Twenty-third", "Twenty-fourth", _
"Twenty-fifth", "Twenty-sixth", _
"Twenty-seventh", "Twenty-eighth", _
"Twenty-nineth", "Thirtieth", _
"Thirty-first")
Cardinal = Array("", "One", "Two", "Three", "Four", _
"Five", "Six", "Seven", "Eight", "Nine", _
"Ten", "Eleven", "Twelve", "Thirteen", _
"Fourteen", "Fifteen", "Sixteen", _
"Seventeen", "Eighteen", "Nineteen")
Tens = Array("Twenty", "Thirty", "Forty", "Fifty", _
"Sixty", "Seventy", "Eighty", "Ninety")
DateIn = CDate(DateIn)
Yrs = CStr(Year(DateIn))
Decades = Mid$(Yrs, 3)
If CInt(Decades) < 20 Then
Decades = Cardinal(CInt(Decades))
Else
Decades = Tens(CInt(Left$(Decades, 1)) - 2) & "-" & _
Cardinal(CInt(Right$(Decades, 1)))
End If
Hundreds = Mid$(Yrs, 2, 1)
If CInt(Hundreds) Then
Hundreds = Cardinal(CInt(Hundreds)) & " Hundred "
Else
Hundreds = ""
End If
DateToWords = Ordinal(Day(DateIn) - 1) & _
Format$(DateIn, " of mmmm ") & _
Cardinal(CInt(Left$(Yrs, 1))) & _
" Thousand " & Hundreds & Decades
End Function

--- VB ki window ko close karain.

SUPPOSE aap ki Cell A1 m date ha tu B1 m forumla asa ho ga

=DateToWords(A1)


Note:- Agar aap ko VB code k enter krne ka masla ho tu MFRANAKAR ki un posts ko read kejya ga jinka aap n hawal deya ha oper.

regards,

[syar]

is ka Shi hal to Sirf Syar Sahib hi dein saktay hain.

Bhai mujhy itna kuch nahee ata jitna aap tawaqa rakhte hain. Is forum p mujh sa zyada expert log hain jo in queries ka jawab d sakte hian.

regards

[M Imran Mugal]

Dear "syar"
me try kro ga abi election ki chotiyan hain mondy ko try kro ga.
Albta coding hai kafi mushkil......
thanks ap ne itna time diya mry ley again thanks

[M Imran Mugal]

mazeed Expert bhaio se request hai k agr un k pas hal ho to wo b shear krain sb dosto ko faida hoga thanks

[M Imran Mugal]

for m2 or m3 ( square or cubic meter/foot etc)
m lekhne k bad

"ALT+0178"

tu square insert ho jae ga.
aur

"ALT+0179"

tu cube yane 3 insert ho jae ga.

Note: ALT hold krne k sath Numeric key pad k 0178 & 9 use karain.

Auto correct ka option excel k proofing tool m hota ha jis k leye

Excel 2007/2010/2013
Excel Option--->Proofing---->Auto Correct Option

Set your desire setting

Note:- Excel 2007 m Menu m sa Radio ka button click krne p option ko select karain. 2010/2013 m File k menu sa option ko select kr sakain ge.

regards

Boht Boht Shukriya Zabardast

[M Imran Mugal]

Dear dosto me ne Excel k aik problem k ley Thread bnai thi use pr kuch Experts dosto ne reply key Problem threebn hall hogai hai me ne socha ap logo se b shear kr lo wo problem b aur us ka hall b isi ley link shear kr raha hn
http://www.itdunya.com/t389265/

Vist kejey ga INSHALLAH kafi faida hoga
Boht Shukriya

[junaidmajeed]

bai mojy urdu my likhna nai ata urdu my kysy likhty hy jab kisi b msg ka reply karna ho?

[syar]

Dear dosto me ne Excel k aik problem k ley Thread bnai thi use pr kuch Experts dosto ne reply key Problem threebn hall hogai hai me ne socha ap logo se b shear kr lo wo problem b aur us ka hall b isi ley link shear kr raha hn
http://www.itdunya.com/t389265/

Vist kejey ga INSHALLAH kafi faida hoga
Boht Shukriya

Kushi hoe k aap ko ap k problem ka solution mil gaya. But do you realized k m n johal deya ha aur jo solutin aap ko aap k thread m btaya gaya ha dono VBA ki coding k through ha. Dosre thread m Spellnumber ki Function use hoa ha jab k m n direct function jo lekha ha wo date ko count krta ha. Give a try to my solution may be you will find it more easy than using spellnumber function.

regards,

[Saleemmsm]

Bhai men new user hu .muje ye btaen k men kaha se ap ka lectur parhu ga ?

[RameezAbbasi]

Assalam o alikum

Bahi mary pass material ke aik list ha , us ma ma krna yah chata hon jo cheaz mary pass 6 din sy zeyada ho jay to us ka color red ho jay ya wo cell highlight ho jay , maslan

Item Received date Expiry date due date
Eggs 15-5-2013 20-5-2013 21-5-2013

abi jasy he date 22 ho to due date ka column red ho jay