View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
James Silverton James Silverton is offline
external usenet poster
 
Posts: 182
Default Change amount into english words according to Indian format

jai wrote on Wed, 25 Apr 2007 23:00:00 -0700:

j I am making appointment letter for the new joinees of my
j company with the help of mail merge, in which I have to put
j salary in number form for example 1219562662 and also in
j figure form for example One Billion Twenty one crore ninty
j five lakh sixty two thousand six hundred sixty two only.

IMHO, unless it is customary in your environment, it is not good
English to write out complicated numbers. I think what you want
would be a number format using the words "crore" and "lakh"
instead of the usual commas. Incidentally, even in rupees, how
do I arrange to get that impressive salary?

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not