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
