HOW CAN I CONVERT NUMBERS INTO TEXT IN A PARTICULAR CELL.

[Jaya]

IS THERE ANY FUNCTION IN EXCEL, WHICH CONVERT TO NUMBER INTO TEXT. IN A
PARTICULAR CELL. FOR EXAMPLE NUMBER 100 INTO "ONE HUNDRED"

 

[Andy Brown]

IS THERE ANY FUNCTION IN EXCEL, WHICH CONVERT TO NUMBER INTO TEXT. IN A
PARTICULAR CELL. FOR EXAMPLE NUMBER 100 INTO "ONE HUNDRED"

There's no built-in function AFAIK. Try the custom function @

http://support.microsoft.com/default.aspx?scid=kb;en-us;213360

Rgds,
Andy