Change amount from number to figure form

[jai]

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.

 

[Pete_UK]

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

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

Hope this helps.

Pete

 

[John]

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)