sridhar wrote:
please somebuddy help me with a formula from a cell which has 3564 in numbers
and in the other I want in words like three thousand five hundered and sixty
four

Hi,

Maybe you can use this link:

http://www.ozgrid.com/VBA/ValueToWords.htm

Regards,
Bondi