Re: $$Excel-Macros$$ Excel spell out word from number
Dear Vikaram herewith i am attached that macro file , u add ur excel file tools - macros -visual basic editor - import , close the file & reopen the excel file type any cell speelrupee(10) or spellrupee(cell reference ) or u send sample excel file i modify send for u J.Mothilal Vellore TN On Thu, Apr 28, 2011 at 7:16 AM, vikram wrote: > Hi, > > > > Can u please send me the file I need to attach as per below instructions. > > > > Thanks for your help. > > > > > > Regards, > > > > Vikram > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *jmothilal > *Sent:* Monday, April 25, 2011 12:05 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Excel spell out word from number > > > > Dear Vikram > > i am attached "rupees-word.bas " macro file with this mail , do the > following steps > >1. open the excel file >2. select tools - macros - visual basic editor - file - import - select > "rupees-words.bas" close it > 3. save the excel file > 4. again open > > > note : Select Macro Security Medium > > Mothilal.J > > > On Sat, Apr 23, 2011 at 6:09 PM, vikram wrote: > > Hi, > > > > Please advice the way by which we can view such macros and add in our > workbooks. > > > > As this function is showing in sheet attached but I am not able to get this > add to new workbook. > > > > Kindly help in this regard. > > > > Regards, > > > > Vikram > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *jmothilal > *Sent:* Saturday, April 23, 2011 12:03 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Excel spell out word from number > > > > Dear Friend > > > here with i am attached fle macro file u add this. > > Thanks with > > Mothilal.j > Vellore-2 > > On Wed, Apr 20, 2011 at 7:33 PM, Tony O wrote: > > I have an Excel spreadsheet with a column of numbers. I would like > each number to be > spelled out, for example > > B1=4 > C1=four > > B2=99 > C2=ninety-nine. > > How would I go about this with a macro? > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > > -- > J.Mohilal > Universal Computer Systems > # 16, Brindavan Complex > Otteri, Vellore-2 > > -- > > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><&
RE: $$Excel-Macros$$ Excel spell out word from number
Hi, Can u please send me the file I need to attach as per below instructions. Thanks for your help. Regards, Vikram From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of jmothilal Sent: Monday, April 25, 2011 12:05 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel spell out word from number Dear Vikram i am attached "rupees-word.bas " macro file with this mail , do the following steps 1. open the excel file 2. select tools - macros - visual basic editor - file - import - select "rupees-words.bas" close it 3. save the excel file 4. again open note : Select Macro Security Medium Mothilal.J On Sat, Apr 23, 2011 at 6:09 PM, vikram wrote: Hi, Please advice the way by which we can view such macros and add in our workbooks. As this function is showing in sheet attached but I am not able to get this add to new workbook. Kindly help in this regard. Regards, Vikram From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of jmothilal Sent: Saturday, April 23, 2011 12:03 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel spell out word from number Dear Friend here with i am attached fle macro file u add this. Thanks with Mothilal.j Vellore-2 On Wed, Apr 20, 2011 at 7:33 PM, Tony O wrote: I have an Excel spreadsheet with a column of numbers. I would like each number to be spelled out, for example B1=4 C1=four B2=99 C2=ninety-nine. How would I go about this with a macro? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---
Re: $$Excel-Macros$$ Excel spell out word from number
Dear Mothilal.j, Thanks for the sollution Badal Singh On Sat, Apr 23, 2011 at 12:02 PM, jmothilal wrote: > Dear Friend > > > here with i am attached fle macro file u add this. > > Thanks with > > Mothilal.j > Vellore-2 > > > On Wed, Apr 20, 2011 at 7:33 PM, Tony O wrote: > >> I have an Excel spreadsheet with a column of numbers. I would like >> each number to be >> spelled out, for example >> >> B1=4 >> C1=four >> >> B2=99 >> C2=ninety-nine. >> >> How would I go about this with a macro? >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > J.Mohilal > Universal Computer Systems > # 16, Brindavan Complex > Otteri, Vellore-2 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- *BADAL SINGH* *09631444534* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Excel spell out word from number
Dear Vikram i am attached "rupees-word.bas " macro file with this mail , do the following steps 1. open the excel file 2. select tools - macros - visual basic editor - file - import - select "rupees-words.bas" close it 3. save the excel file 4. again open note : Select Macro Security Medium Mothilal.J On Sat, Apr 23, 2011 at 6:09 PM, vikram wrote: > Hi, > > > > Please advice the way by which we can view such macros and add in our > workbooks. > > > > As this function is showing in sheet attached but I am not able to get this > add to new workbook. > > > > Kindly help in this regard. > > > > Regards, > > > > Vikram > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *jmothilal > *Sent:* Saturday, April 23, 2011 12:03 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Excel spell out word from number > > > > Dear Friend > > > here with i am attached fle macro file u add this. > > Thanks with > > Mothilal.j > Vellore-2 > > On Wed, Apr 20, 2011 at 7:33 PM, Tony O wrote: > > I have an Excel spreadsheet with a column of numbers. I would like > each number to be > spelled out, for example > > B1=4 > C1=four > > B2=99 > C2=ninety-nine. > > How would I go about this with a macro? > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > > -- > J.Mohilal > Universal Computer Systems > # 16, Brindavan Complex > Otteri, Vellore-2 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Rupees-words.bas Description: Binary data
Re: $$Excel-Macros$$ Excel spell out word from number
press alt+ f11 to view or write a new macro http://www.techbookreport.com/tutorials/excel_vba1.html On Sat, Apr 23, 2011 at 6:09 PM, vikram wrote: > Hi, > > > > Please advice the way by which we can view such macros and add in our > workbooks. > > > > As this function is showing in sheet attached but I am not able to get this > add to new workbook. > > > > Kindly help in this regard. > > > > Regards, > > > > Vikram > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *jmothilal > *Sent:* Saturday, April 23, 2011 12:03 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Excel spell out word from number > > > > Dear Friend > > > here with i am attached fle macro file u add this. > > Thanks with > > Mothilal.j > Vellore-2 > > On Wed, Apr 20, 2011 at 7:33 PM, Tony O wrote: > > I have an Excel spreadsheet with a column of numbers. I would like > each number to be > spelled out, for example > > B1=4 > C1=four > > B2=99 > C2=ninety-nine. > > How would I go about this with a macro? > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > > > > -- > J.Mohilal > Universal Computer Systems > # 16, Brindavan Complex > Otteri, Vellore-2 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Excel spell out word from number
Hi, Please advice the way by which we can view such macros and add in our workbooks. As this function is showing in sheet attached but I am not able to get this add to new workbook. Kindly help in this regard. Regards, Vikram From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of jmothilal Sent: Saturday, April 23, 2011 12:03 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel spell out word from number Dear Friend here with i am attached fle macro file u add this. Thanks with Mothilal.j Vellore-2 On Wed, Apr 20, 2011 at 7:33 PM, Tony O wrote: I have an Excel spreadsheet with a column of numbers. I would like each number to be spelled out, for example B1=4 C1=four B2=99 C2=ninety-nine. How would I go about this with a macro? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- J.Mohilal Universal Computer Systems # 16, Brindavan Complex Otteri, Vellore-2 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Excel spell out word from number
I have an Excel spreadsheet with a column of numbers. I would like each number to be spelled out, for example B1=4 C1=four B2=99 C2=ninety-nine. How would I go about this with a macro? -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel