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