Thread: Excel Problem

Main Excel mein aik amount likhta hon. jesy 10250. ab main chahta hon k excel isy khod ba khod words mein change kar dy.
jesy ( Ten Thousand Two Hundred Fifty Only)
Kya aisa koi formula hy. agr hy to plz help me

watch video

is vedio ka size boht chota hy nazar hi nai ata koch

koi formula nahi hay app ko macro likhni ho gi

ok mackro mill gai hy likhi likhai

check it
http://www.itdunya.com/t329030/

Qutab said:

ok mackro mill gai hy likhi likhai

Dost yaha share kar do to ap ki mehrbani ho gi

ye 2 Notpad ki files hain. aik vo hy k jisy aap copy kro gy to Rupees & only bhi likha hoa aay ga. aur dosri notepad ki file hy jis mein na rupees aay ga aur na only.
jesy
175
1) Rupees One Hundred Seventy Five Only
2) One Hundred Seventy Five.

agr samjh nai aai to bta dena.

Qutab said:

ye 2 Notpad ki files hain. aik vo hy k jisy aap copy kro gy to Rupees & only bhi likha hoa aay ga. aur dosri notepad ki file hy jis mein na rupees aay ga aur na only.
jesy
175
1) Rupees One Hundred Seventy Five Only
2) One Hundred Seventy Five.

is ko excel main use kis tarha karna hai

sab sy pehly excel open karein. us k baad koi bhi amount likhain.
ab Alt+F11 press karein. Visual basic ki window open ho jay gi.
Oper Oper menu ho gi. jis mein aap ne insert per ja kar module per click karna hy.
Ab aik New window open ho jay gi.
is window k andar aap ne note pad ka tamam data paste kar dena hy. jo main ne oper atach kiya hy. 2 note pad ki files hain in mein se aik ka data copy karna hy aur visual basic mein paste karna hy.
ab visual basic ki menu mein jahan file likha hy us mein ja kar nechay nechay close & return MS excel per click karein.
ab Excel ki file open ho gi.
jahan per aap ne ye formula laga hy.
us row mein aap ne sirf ye likhna hy
=spellcurr( Bracket k agy aap amount select karein. ab amount khod ba khod word mein change ho jay gi.

Jis jis ne mujhy PM kya hy un se request hy k main filhal un k PM ka javab nai dy sakta. lehaza tarika mein ne yahan per oper send kar dya hy.