G Guest Apr 10, 2007 #2 Hi, Take a look at the code in this link and modify according to your needs if you need to. http://www.ozgrid.com/VBA/ValueToWords.htm
Hi, Take a look at the code in this link and modify according to your needs if you need to. http://www.ozgrid.com/VBA/ValueToWords.htm
N Norman Jones Apr 10, 2007 #3 Hi Zeeshan, You could download Laurent Longre's MoreFunc addin which is freely downloadable at: http://xcell05.free.fr/ The addin includes the NBTEXT function which converts a positive number into spelled-out text (supports 13 languages). Also see: http://support.microsoft.com/default.aspx?scid=kb;en-us;213360 'How to convert a numeric value into English words in Excel' and http://support.microsoft.com/?scid=kb;en-us;259663 'How To Convert Currency or Numbers into English Words'
Hi Zeeshan, You could download Laurent Longre's MoreFunc addin which is freely downloadable at: http://xcell05.free.fr/ The addin includes the NBTEXT function which converts a positive number into spelled-out text (supports 13 languages). Also see: http://support.microsoft.com/default.aspx?scid=kb;en-us;213360 'How to convert a numeric value into English words in Excel' and http://support.microsoft.com/?scid=kb;en-us;259663 'How To Convert Currency or Numbers into English Words'
