hi i need numbers to be displayed as text for eg. 123 will be displayed as One Hundred Twenty Three
S shiv Nov 5, 2004 #1 hi i need numbers to be displayed as text for eg. 123 will be displayed as One Hundred Twenty Three
P Paul B Nov 5, 2004 #2 shiv, have a look here http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 2003
shiv, have a look here http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q213360 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 2003
E ehntd Nov 5, 2004 #3 Take a look at the following macro and add it to your worksheet. http://www.vba-programmer.com/VB_Code/Converting_Numbers_to_Words.tx
Take a look at the following macro and add it to your worksheet. http://www.vba-programmer.com/VB_Code/Converting_Numbers_to_Words.tx
