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.

Change amount from number to figure form
 

There are a number of examples and links on Bob's site, he

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

Hope this helps.

Pete

On Apr 23, 4:58 pm, 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.

Change amount from number to figure form
 

have a look here http://support.microsoft.com/kb/213360
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"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.