$$Excel-Macros$$ Re: Write numbers in word
Zaheer.., You are always welcome...!! Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/13/09, ~ Z A H E E R ~ zk9...@gmail.com wrote: *Thanx alot Dilip.* On Tue, Oct 13, 2009 at 7:44 AM, Dilip Pandey dilipan...@gmail.comwrote: Hi Zaheer, Solution is enhanced to accommodate the requirement and attached herewith. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/10/09, ~ Z A H E E R ~ zk9...@gmail.com wrote: Hi Dilip, Thanx for your help yaar. Only one problem i faced in Fils section is, when i enter amount as 1250.350 then in words its showing *Fils .35/1000 Only *it should be *Fils 350/1000 Only* * Once again thanx for your efforts to help me. Regards, ZAHEER * On Fri, Oct 9, 2009 at 8:51 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Zaheer, I have modified the code which I had suggested earlier. Please find the attached file with the required modifications done. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/8/09, ~ Z A H E E R ~ zk9...@gmail.com wrote: hello Dilip, I found the answer, but i dose not match my requirements. and dont knw even A of coding. So Plz help me. i need the answer in following format (1,250.365) *Kuwaiti Dinars One Thousand Two Hundred Fifty Fils 365/1000 Only* ** ** Regards, ZAHEER On Fri, Oct 2, 2009 at 4:20 PM, ~ Z A H E E R ~ zk9...@gmail.comwrote: Dear group members, Please help to to write numbers into words automatically. for. eg. if i enter 1,250/365 in any cell then formula or code should give me asnswer in words in any other cell [Currency Name] Öne Thousand Two Hundred Fifty [Currency Name for change] 365/1000 Only i.e Kuwaiti Dinars One Thousand Two Hundred Fifty Fils 365/1000 Only. Number could be answer of any formula. Please help me. Thanx in advance. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Write numbers in word
Hi Zaheer, Solution is enhanced to accommodate the requirement and attached herewith. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/10/09, ~ Z A H E E R ~ zk9...@gmail.com wrote: Hi Dilip, Thanx for your help yaar. Only one problem i faced in Fils section is, when i enter amount as 1250.350 then in words its showing *Fils .35/1000 Only *it should be *Fils 350/1000 Only* * Once again thanx for your efforts to help me. Regards, ZAHEER * On Fri, Oct 9, 2009 at 8:51 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Zaheer, I have modified the code which I had suggested earlier. Please find the attached file with the required modifications done. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/8/09, ~ Z A H E E R ~ zk9...@gmail.com wrote: hello Dilip, I found the answer, but i dose not match my requirements. and dont knw even A of coding. So Plz help me. i need the answer in following format (1,250.365) *Kuwaiti Dinars One Thousand Two Hundred Fifty Fils 365/1000 Only* ** ** Regards, ZAHEER On Fri, Oct 2, 2009 at 4:20 PM, ~ Z A H E E R ~ zk9...@gmail.comwrote: Dear group members, Please help to to write numbers into words automatically. for. eg. if i enter 1,250/365 in any cell then formula or code should give me asnswer in words in any other cell [Currency Name] Öne Thousand Two Hundred Fifty [Currency Name for change] 365/1000 Only i.e Kuwaiti Dinars One Thousand Two Hundred Fifty Fils 365/1000 Only. Number could be answer of any formula. Please help me. Thanx in advance. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Amount in Word (Kuwaiti Dinars) -rev- By DILipandey.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Write numbers in word
Hi Rajeev, Attached solution is customized to meet your requirements as well. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/10/09, Rajeev Nandan rajeev1...@gmail.com wrote: Hi Mr.Dilip, I want to write amount in words in Million style e.g. AED.12,120,545.50 (Dirham- Twelve Millions One Hundred Twenty Thousand Five Hundred Forty Five and Fifty Fills Only.) Please help. Rajeev Nandan Dubai. On Fri, Oct 9, 2009 at 10:05 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Chandra Gupt, I have modified the code which is suggested earlier, to suit indian currency style. Modified code along with an example is attached herewith. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/4/09, Chandra Gupt Kumar kumar.bemlmum...@gmail.com wrote: Dear Dilip, I am not as good as you are. So, could you pls modify the Macro to suite Indian Curreny i.e. Rupees (Rs) and Paisa. Thanks On Sun, Oct 4, 2009 at 4:58 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Zaheer, Just answered this one a while ago. Check out and let me know if you did'nt find that email. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/2/09, ~ Z A H E E R ~ zk9...@gmail.com wrote: Dear group members, Please help to to write numbers into words automatically. for. eg. if i enter 1,250/365 in any cell then formula or code should give me asnswer in words in any other cell [Currency Name] Öne Thousand Two Hundred Fifty [Currency Name for change] 365/1000 Only i.e Kuwaiti Dinars One Thousand Two Hundred Fifty Fils 365/1000 Only. Number could be answer of any formula. Please help me. Thanx in advance. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Amount in Word-Mill-(Kuwaiti Dinars)- By DILipandey.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Write numbers in word
Wht is d answer yar plz send Attachement regards ¢σσℓ ѕα¢нιη On Thu, Oct 8, 2009 at 3:51 PM, ~ Z A H E E R ~ zk9...@gmail.com wrote: hello Dilip, I found the answer, but i dose not match my requirements. and dont knw even A of coding. So Plz help me. i need the answer in following format (1,250.365) *Kuwaiti Dinars One Thousand Two Hundred Fifty Fils 365/1000 Only* ** ** Regards, ZAHEER On Fri, Oct 2, 2009 at 4:20 PM, ~ Z A H E E R ~ zk9...@gmail.com wrote: Dear group members, Please help to to write numbers into words automatically. for. eg. if i enter 1,250/365 in any cell then formula or code should give me asnswer in words in any other cell [Currency Name] Öne Thousand Two Hundred Fifty [Currency Name for change] 365/1000 Only i.e Kuwaiti Dinars One Thousand Two Hundred Fifty Fils 365/1000 Only. Number could be answer of any formula. Please help me. Thanx in advance. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Write numbers in word
Hi Zaheer, I have modified the code which I had suggested earlier. Please find the attached file with the required modifications done. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/8/09, ~ Z A H E E R ~ zk9...@gmail.com wrote: hello Dilip, I found the answer, but i dose not match my requirements. and dont knw even A of coding. So Plz help me. i need the answer in following format (1,250.365) *Kuwaiti Dinars One Thousand Two Hundred Fifty Fils 365/1000 Only* ** ** Regards, ZAHEER On Fri, Oct 2, 2009 at 4:20 PM, ~ Z A H E E R ~ zk9...@gmail.com wrote: Dear group members, Please help to to write numbers into words automatically. for. eg. if i enter 1,250/365 in any cell then formula or code should give me asnswer in words in any other cell [Currency Name] Öne Thousand Two Hundred Fifty [Currency Name for change] 365/1000 Only i.e Kuwaiti Dinars One Thousand Two Hundred Fifty Fils 365/1000 Only. Number could be answer of any formula. Please help me. Thanx in advance. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Amount in Word (Kuwaiti Dinars) - By DILipandey.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Write numbers in word
Hi Chandra Gupt, I have modified the code which is suggested earlier, to suit indian currency style. Modified code along with an example is attached herewith. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/4/09, Chandra Gupt Kumar kumar.bemlmum...@gmail.com wrote: Dear Dilip, I am not as good as you are. So, could you pls modify the Macro to suite Indian Curreny i.e. Rupees (Rs) and Paisa. Thanks On Sun, Oct 4, 2009 at 4:58 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Zaheer, Just answered this one a while ago. Check out and let me know if you did'nt find that email. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/2/09, ~ Z A H E E R ~ zk9...@gmail.com wrote: Dear group members, Please help to to write numbers into words automatically. for. eg. if i enter 1,250/365 in any cell then formula or code should give me asnswer in words in any other cell [Currency Name] Öne Thousand Two Hundred Fifty [Currency Name for change] 365/1000 Only i.e Kuwaiti Dinars One Thousand Two Hundred Fifty Fils 365/1000 Only. Number could be answer of any formula. Please help me. Thanx in advance. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- Indian Currency-Amount to Word.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Write numbers in word
Hi Mr.Dilip, I want to write amount in words in Million style e.g. AED.12,120,545.50 (Dirham- Twelve Millions One Hundred Twenty Thousand Five Hundred Forty Five and Fifty Fills Only.) Please help. Rajeev Nandan Dubai. On Fri, Oct 9, 2009 at 10:05 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Chandra Gupt, I have modified the code which is suggested earlier, to suit indian currency style. Modified code along with an example is attached herewith. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/4/09, Chandra Gupt Kumar kumar.bemlmum...@gmail.com wrote: Dear Dilip, I am not as good as you are. So, could you pls modify the Macro to suite Indian Curreny i.e. Rupees (Rs) and Paisa. Thanks On Sun, Oct 4, 2009 at 4:58 PM, Dilip Pandey dilipan...@gmail.comwrote: Hi Zaheer, Just answered this one a while ago. Check out and let me know if you did'nt find that email. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/2/09, ~ Z A H E E R ~ zk9...@gmail.com wrote: Dear group members, Please help to to write numbers into words automatically. for. eg. if i enter 1,250/365 in any cell then formula or code should give me asnswer in words in any other cell [Currency Name] Öne Thousand Two Hundred Fifty [Currency Name for change] 365/1000 Only i.e Kuwaiti Dinars One Thousand Two Hundred Fifty Fils 365/1000 Only. Number could be answer of any formula. Please help me. Thanx in advance. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Write numbers in word
Dear Dilip, I am not as good as you are. So, could you pls modify the Macro to suite Indian Curreny i.e. Rupees (Rs) and Paisa. Thanks On Sun, Oct 4, 2009 at 4:58 PM, Dilip Pandey dilipan...@gmail.com wrote: Hi Zaheer, Just answered this one a while ago. Check out and let me know if you did'nt find that email. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/2/09, ~ Z A H E E R ~ zk9...@gmail.com wrote: Dear group members, Please help to to write numbers into words automatically. for. eg. if i enter 1,250/365 in any cell then formula or code should give me asnswer in words in any other cell [Currency Name] Öne Thousand Two Hundred Fifty [Currency Name for change] 365/1000 Only i.e Kuwaiti Dinars One Thousand Two Hundred Fifty Fils 365/1000 Only. Number could be answer of any formula. Please help me. Thanx in advance. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Write numbers in word
Hi Zaheer, Just answered this one a while ago. Check out and let me know if you did'nt find that email. Thanks, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On 10/2/09, ~ Z A H E E R ~ zk9...@gmail.com wrote: Dear group members, Please help to to write numbers into words automatically. for. eg. if i enter 1,250/365 in any cell then formula or code should give me asnswer in words in any other cell [Currency Name] Öne Thousand Two Hundred Fifty [Currency Name for change] 365/1000 Only i.e Kuwaiti Dinars One Thousand Two Hundred Fifty Fils 365/1000 Only. Number could be answer of any formula. Please help me. Thanx in advance. --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
