Re: $$Excel-Macros$$ convert numbers into words

t) after install this add-in > > ** ** > > Rajan > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI > *Sent:* Jan/Tue/2012 06:46 > *To:* excel-macros@googlegroups.com &

Re: $$Excel-Macros$$ convert numbers into words

Dear Noorain Excellent Tips.. Thanks Nikhil Shah On Tue, Jan 17, 2012 at 6:45 PM, NOORAIN ANSARI wrote: > Updated Sheet > > > On Tue, Jan 17, 2012 at 6:06 PM, PrIyAnKa wrote: > >> Dear Noorain >> >> It converts with Rupees and i want only for words >> >> E.g. I have "23" in A1 so by formula w

Re: $$Excel-Macros$$ convert numbers into words

Dear Priyanka, Please use SpellNumber() function with Substitue Function. *=SUBSTITUTE(SpellNumber(B4),"Rupees ","") * Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/*

Re: $$Excel-Macros$$ convert numbers into words

Dear Noorain It converts with Rupees and i want only for words E.g. I have "23" in A1 so by formula we need "Twenty Three Only" I hope there may be something in excel treasure for this On Tue, Jan 17, 2012 at 3:54 PM, NOORAIN ANSARI wrote: > Dear Priyanka, > > Please check attached sheet. > Ho

Re: $$Excel-Macros$$ convert numbers into words

In "From Excel" Sheet i have written 525575 (Five Lac Twenty-Five Thousand Five hundred and Seventy-Five) but we are getting result as per below : (Red highlighted) *Type No Here* 525575 *Convert in Text* five hundred and twenty-five thousand five hundred and seventy-five On Tue, Jan 17,

Re: $$Excel-Macros$$ convert numbers into words

i think her system macro is disable.   coz, i have checked its working. From: NOORAIN ANSARI To: excel-macros@googlegroups.com Sent: Tuesday, 17 January 2012 1:43 PM Subject: Re: $$Excel-Macros$$ convert numbers into words Hi Priyanka, Can you explain what

Re: $$Excel-Macros$$ convert numbers into words

Hi Priyanka, Can you explain what error you are getting.. because VBA+Excel both are working fine On Tue, Jan 17, 2012 at 12:56 PM, PrIyAnKa wrote: > Dear Noorain > > Kindly see there is some error in for excel file > > > On Mon, Jan 16, 2012 at 5:07 PM, PrIyAnKa wrote: > >> Thanks Noorain >>

Re: $$Excel-Macros$$ convert numbers into words

Thanks Noorain On Mon, Jan 16, 2012 at 4:54 PM, NOORAIN ANSARI wrote: > Dear Priyanka, > > Please see attached sheet with Excel & VBA both > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/* > *http://noorain-ansari.blogspot.

$$Excel-Macros$$ convert numbers into words

Dear Team Can we have a formula which converts numbers in to word? E.g. I have "23" in A1 so by formula we need "Twenty Three Only" We do not need Rupees or pound any just simple word -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor threa