how to convert the number into its text format

[pankaj]

i want to convert a number for example 1245 to its text
format (one thousand two hundred forty five )

please tell how to do this in excel (office xp)

 

[Ron Rosenfeld]

i want to convert a number for example 1245 to its text
format (one thousand two hundred forty five )

please tell how to do this in excel (office xp)

Download and install morefunc.xll from

http://perso.wanadoo.fr/longre/excel/pages/Downloads.htm#Morefunc.xll.

and use the NUMTEXT function.


--ron

 

[Haldun Alay]

Hi,

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

--
Regards

Haldun Alay

To e-mail me, please remove AT and DOT from my e-mail address.
"Ron Rosenfeld" <[email protected]>, iletide sunu yazdi

i want to convert a number for example 1245 to its text
format (one thousand two hundred forty five )

please tell how to do this in excel (office xp)

Download and install morefunc.xll from

http://perso.wanadoo.fr/longre/excel/pages/Downloads.htm#Morefunc.xll.

and use the NUMTEXT function.


--ron