Kindly read the answer Gary's Student gave below regarding custom formatting.


Gord Dibben MS Excel MVP

On Wed, 16 Mar 2011 06:16:04 GMT, barun sinha wrote:

kindly send the formulae to use 100 separator instead of 1000 seperator in MS excel while numbering

On Friday, November 23, 2007 12:43 AM monisankar_dutt wrote:

Suppose A1 number is 120000.00. Now I want to separate it by 1000 & 100, i.e.
1,20,000.00. If I format the cell - Number & click on 1000 separatetor. It
show like 120,000.00. Is there any custom format to show 1,20,000.00 in excel
2003


On Friday, November 23, 2007 6:07 AM GarysStuden wrote:

--
Gary''s Student - gsnu200758


"Montu" wrote:


On Friday, November 23, 2007 6:09 AM GarysStuden wrote:

Format Cells... Number Custom:

0\,00\,000.00
--
Gary''s Student - gsnu200758


On Friday, November 23, 2007 7:41 AM monisankar_dutt wrote:

Many Many Thanks to you - Gray. Hoping get more support in future. Have nice
day.

"Gary''s Student" wrote:


Submitted via EggHeadCafe
Profiling and Optimizing VBA
http://www.eggheadcafe.com/tutorials...izing-vba.aspx