http://support.microsoft.com/default...b;en-us;213360

this ms link shows you how to convert numbers to text

or you can download an add-in called more functions, you can get it
here

http://xcell05.free.fr/

when you have the add-in the formula for say dollars and cents would
be:

=NBTEXT(A2,2,1,"dollar!","dollars","Cents")
;)


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=521505