Gerald wrote:
Dears,

would appreciate if any help on my below query

I have currency in numbers which I need in words, e.g. if I enter in field
A1 505 , once I come out of the field, in B1 I should get Five Hundred And
Five Dollars
thanks

Hi Gerald,

This link to Microsoft might help you:

http://support.microsoft.com/?kbid=213360

Regards,
Bondi