Friends I want to put comma automatically into the digits like this- 10,00,000 Or 1,00,000
For this I want to use a formula. I also know that I can do this by format cell>number>use 1000 separator (,). But I need a formula for this task because we can use comma like eastern (especially Indian) in M S Excel 2010 and its further versions but I have M S Excel 2007 in windows XP which does not allow to use comma like eastern (especially Indian). It puts comma like this- 100,000,000 or 1,000,000 so I searched on net for a formula I found this formula
=REPLACE(A1,FIND(" ",A1),0,",")
If this formula is in b1 and any name is written in a1 cell like joe desuja then it puts comma after first name and the result (in b1) is this- joe, desuja. I want this kind of formula which should work with the numeric digits. Kindly help me. Thanks a lot.