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
Expenses Claim Form(1).xls
Description: MS-Excel spreadsheet
