Converting figures into words In Excel
Hi,
Could anybody help me. Just need to know how to convert figures into words automatically. ie, when I enter a figure , I need it to be displayed in words. To be more precise, when I enter a cheque amount in a cell, I need the amount to be converted into words and displayed in the next cell in Excel. Please help Regards Mahesh |
Converting figures into words In Excel
You'll find a function on this web page, you can change
the wording to suit your locale requirements. http://www.planet-source- code.com/vb/scripts/ShowCodeAsText.asp? txtCodeId=520&lngWId=-1 regards KM -----Original Message----- Hi, Could anybody help me. Just need to know how to convert figures into words automatically. ie, when I enter a figure , I need it to be displayed in words. To be more precise, when I enter a cheque amount in a cell, I need the amount to be converted into words and displayed in the next cell in Excel. Please help Regards Mahesh . |
Converting figures into words In Excel
Mahesh.P.P wrote:
Just need to know how to convert figures into words automatically. ie, when I enter a figure , I need it to be displayed in words. Try this, from the MS Knowledgebase http://support.microsoft.com/default...b;en-us;140704 Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - reply in newsgroup |
Converting figures into words In Excel
my notes say "consult Laurent Longre's" site. try to get it through google
Mahesh.P.P wrote in message ... Hi, Could anybody help me. Just need to know how to convert figures into words automatically. ie, when I enter a figure , I need it to be displayed in words. To be more precise, when I enter a cheque amount in a cell, I need the amount to be converted into words and displayed in the next cell in Excel. Please help Regards Mahesh |
All times are GMT +1. The time now is 09:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com