View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Shashank
 
Posts: n/a
Default How do I Change Numbers in text in MS-Excel

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.