See if Ozgrid doesn't have a solution for you:
http://www.ozgrid.com/VBA/ValueToWords.htm


"Subhashis Bhowmick" wrote:

Sir,

I am working in a finance department, can you help me in creating a formula
which can return the value of a perticular cell in text, such as 2564
resultant cell- two thousand five hundred and sixty four only.

Regards

Subhashis Bhowmick