0
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.
excel 2003 should support formatting cells with a custom notation. That is definitely the preferred method. It probably fails because the locale is not recognised in XP, but a custom formatting, where you specify the notation yourself should still work. – LPChip – 2015-12-02T13:52:09.690