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