try out this small custom function straight from miscrosoft help
http://support.microsoft.com/default...b;en-us;213360
U need to customize it to your need.
"Yaman Mahajan" wrote:
Hi,
I am Using Excel for my Billing Purposes, i want that excel print the amount
in words for Eg: if my total is 3,046.78 then i want excel print this numeric
digit in Ruppes Three Thousand Fourty Six & Paise Seventy Eight Only.