Change amount from number to figure form
 

I am making appointment letter for employees using mail merge option. In
appointment letter I have to put salary in number form i.e. 121000 and also
in figures i.e. One lakh twenty one thousand. I have a coloumn in excel where
I have all the salary package in number form. Is it possible, for excel to
automatically convert this number form salary into figure ? Any assistance
would be greatly obliged.

Jai

Change amount from number to figure form
 

Numbers to words
Bob Phillips' site for help on this.

http://www.xldynamic.com/source/xld.xlFAQ0004.html

or Bernd Plumhoff's site

http://www.sulprobil.com/html/spellnumber.html

or

http://www.ozgrid.com/VBA/ValueToWords.htm

or

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

best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"jai" wrote in message
...
I am making appointment letter for employees using mail merge option. In
appointment letter I have to put salary in number form i.e. 121000 and
also
in figures i.e. One lakh twenty one thousand. I have a coloumn in excel
where
I have all the salary package in number form. Is it possible, for excel to
automatically convert this number form salary into figure ? Any assistance
would be greatly obliged.

Jai

Change amount from number to figure form
 

See these links on creating a User Defined Function that will convert numbers
into spelled out words:

http://support.microsoft.com/default...b;en-us;213360
http://www.ozgrid.com/VBA/ValueToWords.htm

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"jai" wrote:

I am making appointment letter for employees using mail merge option. In
appointment letter I have to put salary in number form i.e. 121000 and also
in figures i.e. One lakh twenty one thousand. I have a coloumn in excel where
I have all the salary package in number form. Is it possible, for excel to
automatically convert this number form salary into figure ? Any assistance
would be greatly obliged.

Jai