Thread: spell number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
N V Siva Prasad. N V Siva Prasad. is offline
external usenet poster
 
Posts: 1
Default spell number

i want a function by which i can convert the calculated figuers in spelling
say for e.g if in my invoice file the amount comes to 127367.25 .i hav eto
write the complete amount in words.is there any formula,function which can
derive the amount in words as in above e.g. convert Amount of 127367.25 to
words as one lack twenty seven housand three hundred sixty seven and twenty
five paise.

so i would like to make the function as tousands, lakhs and crorers