Hi Manhar,
Thanks for your help. I wanted a written formula or such rather than .xls file. Secondly,if there is no such formula then how I can use this .xls file for converting all numbers in text as mentioned below such as converting below sample data. 1000 2000 3000 4000 5000 100 200 Regards, Vikram Ahuja From: manhar prajapati [mailto:prajapati.man...@gmail.com] Sent: Friday, March 11, 2011 2:53 PM To: excel-macros@googlegroups.com Cc: vikram Subject: Re: $$Excel-Macros$$ Formula Query Dear Vikram Please use attach addins file. Regards Manhar Prajapati On Fri, Mar 11, 2011 at 11:53 AM, vikram <vikramahuj...@gmail.com> wrote: Hi, Please help if anybody can provide formula regarding below query: Whenever we type any amount i.e. in number such as Rs.1000.00 it converts in words such as Rs. One thousand only. Regards, Vikram Ahuja -- ---------------------------------------------------------------------------- ------ 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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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
