Hi Dave, wonderful its a great job
Regards ROHAN On Sun, Feb 6, 2011 at 4:40 AM, Dave Bonallack <davebonall...@hotmail.com>wrote: > You're welcome. > Dave. > > > Date: Sat, 5 Feb 2011 20:31:35 +0530 > > Subject: Re: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT > > From: rajeshkainikk...@gmail.com > > > To: excel-macros@googlegroups.com > > > > Hi Dave > > Excellent work, I never thought that the conversion can be done by > formula. > > Regards > > Rajesh Kainikkara > > On 2/5/11, Dave Bonallack <davebonall...@hotmail.com> wrote: > > > > > > Hi Solomon, > > > Have a look at the attached. Most numbers-to-text conversions are done > with > > > VBA, but this one is done with formulas and functions. It uses a bunch > of > > > cells to do its workings. In your case I have put those cells in the > range > > > A50:K62. If you need that range for something else, then you'll have to > move > > > the whole block of cells to an unused part of the sheet. > > > Hope this helps > > > Regards - Dave. > > > > > > > > > > > > From: faithful1...@gmail.com > > > Date: Sat, 5 Feb 2011 08:52:55 +0400 > > > Subject: Fwd: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT > > > To: excel-macros@googlegroups.com > > > > > > > > > > > > Can someone define formula because I dont know macros. > > > Regards, > > > Solomon > > > > > > > > > > > > ---------- Forwarded message ---------- > > > From: solomon raju <faithful1...@gmail.com> > > > Date: Thu, Feb 3, 2011 at 3:14 PM > > > Subject: $$Excel-Macros$$ HOW TO CONVERT THE AMOUNT IN TEXT > > > To: excel-macros@googlegroups.com > > > > > > > > > > > > > > > Hi All, > > > > > > Please find the attached excel file and give me some formula to convert > the > > > amount in text. > > > > > > Regards, > > > Solomon > > > > > > -- > > > > ---------------------------------------------------------------------------------- > > > 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, > > > Solomon > > > > > > -- > > > > ---------------------------------------------------------------------------------- > > > 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 > > > > > > > -- > > > ---------------------------------------------------------------------------------- > > 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 > -- ---------------------------------------------------------------------------------- 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
