numbers to be displayed as text

[shiv]

hi
i need numbers to be displayed as text
for eg. 123 will be displayed as One Hundred Twenty Three

 

[Paul B]

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

 

[ehntd]

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