i want to convert the Currency appering in Number to Characters

[Saif]

like i have 2568.38

in another cell i need Two thousand five hundred Sixty Eight Dollars and
Cents Thirty Eight,

in fact i had this functioin in my excell before but not after i update i
can't find it.

i got the program some where from Microsoft website, can any one help me
please

 

[Mike H]

Saif,

Here's the code

http://support.microsoft.com/kb/213360

Mike

 

[Saif]

Thanks mike, Tested Ok, this was exactly what i need

Thanks,