K Komal Aug 25, 2008 #1 In 1 cell i have amount 3,400.00. how do i create a formula in another cell for amount in words?
T Tom Hutchins Aug 25, 2008 #3 Check out the NBTEXT function in Laurent Longre's free MoreFunc addin, which you can download: http://xcell05.free.fr/ There are also some Microsoft articles you could check out: http://support.microsoft.com/default.aspx?scid=kb;en-us;213360 'How to convert a numeric value into English words in Excel' http://support.microsoft.com/?scid=kb;en-us;259663 'How To Convert Currency or Numbers into English Words' If you are new to macros, this link to Jon Peltier's site may be helpful: http://peltiertech.com/WordPress/2008/03/09/how-to-use-someone-elses-macro/ Hope this helps, Hutch
Check out the NBTEXT function in Laurent Longre's free MoreFunc addin, which you can download: http://xcell05.free.fr/ There are also some Microsoft articles you could check out: http://support.microsoft.com/default.aspx?scid=kb;en-us;213360 'How to convert a numeric value into English words in Excel' http://support.microsoft.com/?scid=kb;en-us;259663 'How To Convert Currency or Numbers into English Words' If you are new to macros, this link to Jon Peltier's site may be helpful: http://peltiertech.com/WordPress/2008/03/09/how-to-use-someone-elses-macro/ Hope this helps, Hutch
